Combining Data from 2 Different pbix Files

[markefrody]

Hi,

Is there a way to create a new report in Power BI Desktop using different appended data tables from 2 different pbix files?

For example:

Power BI Desktop file 1 (Appended Table A) + Power BI Desktop file 2 (Appended Table B) 

=
New Power BI Desktop file (Appended Table A + Appended Table B)

Appreciate your kind advice. Thanks!

Best regards,
Mark V.

[amitchandak · Accepted solution]

@markefrody , Try to merge file using ALM toolkit and then you can append

How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc

Otherwise consider Direct query on power bi dataset

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-servic...

[markefrody]

@amitchandak thank you very much for this. Will look into it.