Forum Discussion
Combine multiple xlsx files into a single single field for data & reporting
I have searched the forum and while I am sure a solution exist I could not find one. Please help direct me to another thread if there is a solution I can use for this question. I have a xlsx file...
v-xjiin-msft
Solution Sage
Solution SageHi DJPoloMan,
If these xlsx files have relationships among each other. I think you can try Merge or Append in Edit Queries in Power BI.
Reference: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
http://radacad.com/append-vs-merge-in-power-bi-and-power-query
Thanks,
Xi Jin.