Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi all, good afternoon
I am having challenges to combine files in powerbi, even though file structure is identifical, the option is disabled.
I can't add all files in one folder, and creating all queries for 100 files would take forever.
Anyone faced this challenge or know a workaround?
Solved! Go to Solution.
Hi @Anonymous ,
Are you using Folder connector? According to your screenshot, Append Queries feature should work for you.
Best Regards,
Jay
Hi @Anonymous ,
Are you using Folder connector? According to your screenshot, Append Queries feature should work for you.
Best Regards,
Jay
Hi, Yes, however for some reason I cannot link the folder but only individual files from Sharepoint, that's why I have linked individual files as source.
Checking online I saw that it might requires Office365, so asking this internally for my company.
@Anonymous , You have to use append ?
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |