Forum Discussion
Merging data of 2 Power BI report with Different data source
I have 2 Power BI Reports , data source for both reports are different.
I want Primary Sales % Growth , which is in Power BI Report 1 ,in Power BI Report 2 which has Secondary Sales % Growth, so that I can compare Primary Sales % Growth with My Secondary Sales % Growth.
Is it possible?
I want to create new Page in Power BI Report 2 to compare % Primary & Secondary Growth.
Hello AartiD ,
Have you tried using the dashboard concept ?
You can pin images from different dashboards and have them on the same screen.
https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboards
Please feel free to kudos or approve my answer as a solution if it works for you.
Have a nice day,
VivienYes, you can compare them. If you just need visuals side-by-side, create a Power BI Dashboard and pin visuals from both reports. But if you need a single chart comparison, connect Report 2 to Report 1’s dataset (composite model) and build a new comparison page.
Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst
5 Replies
- vivien57
Super User
Hello AartiD ,
Have you tried using the dashboard concept ?
You can pin images from different dashboards and have them on the same screen.
https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboards
Please feel free to kudos or approve my answer as a solution if it works for you.
Have a nice day,
Vivien - govind_021
Super User
Yes, you can compare them. If you just need visuals side-by-side, create a Power BI Dashboard and pin visuals from both reports. But if you need a single chart comparison, connect Report 2 to Report 1’s dataset (composite model) and build a new comparison page.
Best Regards
Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
Let's Connect
Linkdin - www.linkedin.com/in/govind-sapkade-845104225
Youtube - http://www.youtube.com/@govind_dataanalyst - AnonymousNot applicable
Hi AartiD,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to govind_021 and vivien57 for prompt and helpful responses.
Just following up to see if the Response provided by community members were helpful in addressing the issue.
If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar - AnonymousNot applicable
Hi AartiD,
Just following up to see if the Response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
Best regards,
Prasanna Kumar
- AnonymousNot applicable
Hi AartiD,
Just following up to see if the Response provided by community members were helpful in addressing the issue.
If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.
Best regards,
Prasanna Kumar