Merging Two Power BI Reports into a Single File While Keeping Separate Data Models

[danishrizvi]

I have two Power BI reports, each with its own data model, DAX Measures, and visualizations. I would like to combine them into a single Power BI file while ensuring that:

• Both reports retain their separate data models (without merging datasets).
• The DAX measures and visualizations remain independent.
• The reports exist as separate tabs/pages within the same file.

What would be the best approach to achieve this?

[connect]

@danishrizvi Here is the answer!! Please do watch this video and I am sure you'll be bale to find your answer:

[rohit1991]

Hi @danishrizvi

Power BI doesn’t support combining two reports into a single .pbix file while keeping separate models. Each file can only have one data model.

If you just want to present both together, the best workaround is to publish both reports to a workspace and then bundle them into a single Power BI App. That way, users can access them in one place, but each report stays separate.

[nilendraFabric · Accepted solution]

Hello @danishrizvi 

Merging two Power BI reports into a single file while maintaining separate data models is not natively supported because a `.pbix` file can only contain one unified data model.

Use Power BI Apps for Unified Access:
1. Publish Both Reports: Upload the two reports to a Power BI workspace.
2. Create an App: Bundle both reports into a single app for stakeholders. Users see both reports as separate entities in one app interface

[v-aatheeque]

Hi @danishrizvi ,

If the answer posted by @nilendraFabric  was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @danishrizvi ,

If the answer posted by @nilendraFabric  was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @danishrizvi ,

 If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!