cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stone2299
New Member

How to combine multiple PowerBI reports into one table

Hello,

 

I am trying to find a way how to merge the data from four reports which have been set up by different regions. The underlying data is similar (ie each dataset contains the same columns, maybe with slight name differences), and I have access to all regional dashboards.

 

What is the best way to combine all regions into one big - global - table to run analysis on the full dataset?

 

I tried importing the PowerBI datasets, but then I am not able to see how to make transformations and merge them into one?

 

Thanks for any pointers!

1 ACCEPTED SOLUTION
MartijnW
Frequent Visitor

Hi Stone,

 

The recommended way to create reusable data that you can use throughout multiple reports is by creating Dataflows. In Power Query, you can then transform the column names and append the queries to generate the global table. I recommend you think about what kind of analyses you need to run and at what level of granularity, as well. That way you can also group the data to a more managable size for the report you want to build.

 

Importing multiple datasets in a single report is not possible, last I checked.

 

Here is some information on these topics:

https://powerbi.microsoft.com/it-ch/blog/introducing-power-bi-data-prep-wtih-dataflows/

https://docs.microsoft.com/en-us/power-query/append-queries 

 

Please accept this as a solution if these are the pointers you're looking for and repond if anything is unclear.

 

Kind regards,

Martijn Wijnands

View solution in original post

2 REPLIES 2
MartijnW
Frequent Visitor

Hi Stone,

 

The recommended way to create reusable data that you can use throughout multiple reports is by creating Dataflows. In Power Query, you can then transform the column names and append the queries to generate the global table. I recommend you think about what kind of analyses you need to run and at what level of granularity, as well. That way you can also group the data to a more managable size for the report you want to build.

 

Importing multiple datasets in a single report is not possible, last I checked.

 

Here is some information on these topics:

https://powerbi.microsoft.com/it-ch/blog/introducing-power-bi-data-prep-wtih-dataflows/

https://docs.microsoft.com/en-us/power-query/append-queries 

 

Please accept this as a solution if these are the pointers you're looking for and repond if anything is unclear.

 

Kind regards,

Martijn Wijnands

Thank you so much for the pointer - this seems to be the way to go indeed for me!

Helpful resources

Announcements
Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.