Combining Data from 2 Different pbix Files

Question

Hi,&nbsp;Is there a way to create a new report in Power BI Desktop using different appended data tables from 2 different pbix files?&nbsp;For example:Power BI Desktop file 1 (Appended Table A) + Power BI Desktop file 2 (Appended Table B)&nbsp;=New Power BI Desktop file (Appended Table A + Appended Table B)&nbsp;Appreciate your kind advice. Thanks!Best regards,Mark V.

amitchandak · Accepted Answer

markefrody , Try to merge file using ALM toolkit and then you can append 
&nbsp;
How to ALM toolkit to merge Power BI files/Meta: https://youtu.be/lio62VRkOnc 
&nbsp;
&nbsp;
Otherwise consider Direct query on power bi dataset
&nbsp;
https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/

Forum Discussion

Combining Data from 2 Different pbix Files

2 Replies

Related content

Combining files from sharepoint with slightly different layouts

Combine files with different column structure

Power Query Combine Multiple Files From Folder

Tables combine

Combining files with different field names from Sharepoint folder