Forum Discussion
dynamically import files from a folder WITHOUT combining them
Hi all, I'm looking to upload multiple files of the same type from a single folder into Power BI Desktop. However, in this case, I don't want to combine them into a single query. How can I dynamic...
Import all your files into one table and drag the filename-field into the legend of your chart and you get what you've shown in the pic.
If you don't want to see all your files in one pic, filter them on the visual-level.
But DON'T import identical tables into multiple queries!
You can also check this file with a mockup from some sample data: https://1drv.ms/u/s!Av_aAl3fXRbehbEZQCClJ9yv9MhfZQ
Imke Feldmann
www.TheBIccountant.com -- How to integrate M-code into your solution -- Check out more PBI- learning resources here
Hello Imke,
I am facing similar issue, but with a twist, I need to import "Non-Identicale" CSV files into multiple queries. Any idea, how to do that?
BR,
Mohamed.