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,
The scenario, I have a SharePoint Folder which contains two .xlsx files. The two files have different data structures. When attempting to do a direct load (via Get Data) an error is thrown due to not being able to union the different structures - so I believe.
Is this what you guys are experiencing?
The workaround I found was not to load directly but to go into edit mode and for one of the queries 'set as new query' on the binary. Now the two files have their own queries. Navigate the queries to the Table link then double click to expand the table for each query. From this point I am then able to load the files to Power BI without errors.
Thought I'd let you know my workaround for those who are having trouble. Do let me know if there is another/correct solution to loading (directly) multiple files with different structures.
Cheers,
Dan.
Hi @Anonymous,
Thanks for sharing the workaround.
Thanks,
Lydia Zhang
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |