Forum Discussion

harirao's avatar
harirao
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Assistance Required: Combining Power BI Dashboards

Hi Team, I have created two different Power BI dashboards, each using a separate Excel source file with different data. Could you please assist me in understanding if it is possible to combine both...
  • Ritaf1983's avatar
    1 year ago

    Hi harirao 

    If you are referring to two separate reports in two different PBIX files, it is not possible to directly merge them into one file. Instead, you can do the following:

    1. Open one of the PBIX files.
    2. Add the data sources from the second PBIX file into the first one.
    3. Adjust and integrate the data model to ensure it aligns with both datasets.
    4. Update the measures, calculations, and visualizations to fit the combined data.

    If you are referring to the dashboard feature in Power BI Service (which does not exist in Power BI Desktop), you can:

    1. Publish both reports (PBIX files) to the same workspace in Power BI Service.
    2. Create a new dashboard in the workspace and pin visualizations from both reports onto it.

    Important Notes:

    • Each visualization on the dashboard is interactive and serves as a direct link to the corresponding report.
    • The dashboard visualizations reflect the data as of the latest refresh for the respective dataset.

    More information about dashboards here :
    https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboards

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