Best approach for combining existing Data Models into one report

[julienvdc]

we a couple of .pbix reporting analytics/data that are each dedicated to a tool (ticketing system, finance/budgeting tool, inventory system). Each of these have relationships, calculated columns, measures, etc.

We would now like to build a report that combines data from each of these existing report in a global  one. It won't hold all the same visuals we have in the dedicated reports, it'll hold a few key metrics (which are not necessarily visuals from the dedicated reports - so pinning visuals into a dashboard is not an option). We would also like to apply RLS to this global report.

What would be the recommended approach for doing this?

[julienvdc]

Hey @Anonymous thanks for your reply.

Sorry if it wasn't clear enough. I am essentially looking at ways to gather data models that have been worked (power query transformations, measures, ...) on various reports under one single report. I have looked into Direct Queries but it's quite limited what you can do on these DMs and RLS doesn't seem to be working...

[Anonymous · Accepted solution]

Hi @julienvdc ,

Unfortunately, there is currently no way to assemble multiple pbix files directly on a single pbix file. You can blend multiple data sources in a single report and then rewash the data to build the model. Or you can use Power Query to manually paste the code in Advanced Editor, avoiding the need to rewash the data, you may need to manually recreate the measures and calculated columns.

Power Query:
Open each of your existing reports in Power BI Desktop. In each report, navigate to the Advanced Editor.  Create a new Power BI report and paste these queries into the Advanced Editor of the new report.

DAX Studio:
Open DAX Studio. Connect to the data model of each existing report. Drag and drop the necessary data tables and measures into a new query. Execute the query to retrieve the data. Use this data in your consolidated report.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous]

Hi @julienvdc ,

To combine data from multiple Power BI reports, you can use the "Merge Queries" functionality in the Query Editor . Here are the steps to follow:

1. Open a new Power BI project in the desktop version of Power BI.
2. Select "Get Data" from the home menu and choose the data source(s) you want to import.
3. Use the Query Editor to clean, filter, and format the data as needed.
4. Select "Merge Queries" from the home menu to merge multiple data queries.

Once you have imported the datasets and merged the queries, you can build your new report with the consolidated data. You can also apply Row-Level Security (RLS) to this global report.

Please note that you cannot combine reports from different workspaces, but you can pin visuals from different reports to a single dashboard.

You can refer to the similar posts that may be helpful to you: 

Can I combine 2 different data sources in the same... - Microsoft Fabric Community

How to merge two/multiple power bi reports/dashboa... - Microsoft Fabric Community

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.