The BEST way to combine files in Power BI so you don’t lose columns – Part 2
In a previous video, I showed you how to combine files without losing columns and you had a ton of questions that I will address in this video.
Table of contents:
1. How to promote headers inside a table
2. How that will prevent columns from combining the wrong way
3. How to add filename to the tables before expanding them.
Watch the tutorial:
Links to the mentioned resources
And here is Part 1: