Forum Discussion
How to combine multiple PowerBI reports into one table
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
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!