Forum Discussion
Gathering data from Folder (excel files)
Hello Experts, I would like to ask whether the following is possible or not and what kind of solution can be applied for it. Currently I have it working but modifying the excel files before get ...
Nevermind guys, I have finally found the solution after looking for it for more than 6 months!
Please, have a look on this video https://www.youtube.com/watch?v=mZbD8aduIJU
It's exactly the problem I was facing (when having new columns plus having the right data under the exact column). In this case, where no data for that column I will get "null" which is exactly what I needed and most importantly, it's dynamic.
Final result:
Thanks for your time though, I truly appreciate it 🙂
I would recommend unpivoting the data everytime you import. Power BI works better with unpivoted data anyway. You can still build your pivoted table in the visual anyway, so there won't be any loss.
EDIT: Power Query has a pivot/unpivot function