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.
Hello, Is itt possible to merge automatically the data in the data models of various excel files with the same data model and file structure?
Ty,João
Hi @Anonymous ,
Power BI as an option to get data from folders, in this case a function is created and all files on that folder are treated in the same way, so you only have to setup the steps of the query once and the information will be merged.
Check the documentation on PBI.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsBut I can't access each data model directly via importing folder/files, right?
Hi @Anonymous ,
If the files have the same models / format it will be done automatically.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |