Forum Discussion
Merging PBI dashboards
Hi All,
Please Suggest how to merge 2 PBI dashboards into one. I’m currently having 2 different dashboards (2 Databases, 2 PBI files) but I need to merge into one without recreating views again in report view.
Thank you.
Hi Snagalapur
I don't think there is an automatic way to merge them. You can copy-paste visuals from one report to another but in most cases it will require that the tables/measures/columns they're referencing exist in the target report - not much of a problem if you're using the same semantic model. If you the two reports use different semantic models, you can connect to them using direct query but you will still have to recreate the views/reports.
5 Replies
Hi Snagalapur
I don't think there is an automatic way to merge them. You can copy-paste visuals from one report to another but in most cases it will require that the tables/measures/columns they're referencing exist in the target report - not much of a problem if you're using the same semantic model. If you the two reports use different semantic models, you can connect to them using direct query but you will still have to recreate the views/reports.
Hi Snagalapur
Thank you for reaching out to the Microsoft Fabric Forum Community.
danextian Thanks for your inputs.
I hope the information provided by user was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hi Snagalapur
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Hi Snagalapur
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
To merge two Power BI dashboards built on different databases without recreating views manually, you can:
Use Power BI Desktop to import both PBIX files as datasets.
Use Shared datasets or composite models to connect to both data sources within one new report file.
In Power Query, you can append or merge data tables from both databases if schemas are compatible.
To bring visuals from one report into another, open both PBIX files, select visuals/pages in one, copy (Ctrl+C) and paste (Ctrl+V) into the main report. This preserves formatting and visual settings.
