Forum Discussion

tomperro's avatar
tomperro
Helper V
1 year ago
Solved

Measure from another report

Is it possible to pull a value from one power bi report to another?

 

I have 1 report with totals and a seperate report that has the details. 

 

I would like to bring the overall total over to the details report without re-creating everything.

Need Help
  • ajaybabuinturi's avatar
    ajaybabuinturi
    1 year ago

    Hi tomperro,
    Yes, it is possible to pull values from one Power BI report into another, but not directly like linking Excel cells you can use "Power BI semantic Models" connector

    Make sure both reports are in the Power BI Service and in same workspace

    • Publish the dataset from Report A

    • Then in Report B, instead of importing data, choose “Power BI semantic Models”

    Steps to connect the semantic model:

    1. In Power BI Desktop (for the detail report), choose:

      • Get Data → Power BI semantic Models

    2. Select the dataset from your “Totals” report

    3. Use the relevant tables/measures in your new report and no need to recreate logic.

     

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

4 Replies

  • ajaybabuinturi's avatar
    ajaybabuinturi
    Super User
    1 year ago

    Hi tomperro,
    Yes, it is possible to pull values from one Power BI report into another, but not directly like linking Excel cells you can use "Power BI semantic Models" connector

    Make sure both reports are in the Power BI Service and in same workspace

    • Publish the dataset from Report A

    • Then in Report B, instead of importing data, choose “Power BI semantic Models”

    Steps to connect the semantic model:

    1. In Power BI Desktop (for the detail report), choose:

      • Get Data → Power BI semantic Models

    2. Select the dataset from your “Totals” report

    3. Use the relevant tables/measures in your new report and no need to recreate logic.

     

    Thanks,
    If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

    • tomperro's avatar
      tomperro
      Helper V
      1 year ago

      I do not see "Use a dataset already published to the Power BI Service"