Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |