Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'd like users to be able to drop individual files (all with the same structure) into a single directory, and then have power bi automatically combine them into a single dataset. Please could you tell me if/how this can be done?
It was quite a common requirement in my VBA days but can't seem to find this on google for Power BI.
Thanks for any pointers,
CM
Solved! Go to Solution.
Hey @CloudMonkey ,
sure, that is also possible.
For that chose "Folder" as your data source:
Once you chose the folder you have the possibility to "Combine" all the files in that folder:
This is going to combine all files in that folder to a single table.
Fantastic thank you Denis 😁
Hey @CloudMonkey ,
sure, that is also possible.
For that chose "Folder" as your data source:
Once you chose the folder you have the possibility to "Combine" all the files in that folder:
This is going to combine all files in that folder to a single table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |