Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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ês