Forum Discussion

areias_br's avatar
areias_br
Helper I
1 year ago

Gather Measures from a PBI File into another Power Bi File

Hi,

I have several KPIs. Each KPI is in different Power BI file which as they come from different data sets, only a few tables are the same such as Calendar Table and Vessels Name. Usually the KPI are measures.

 

Is it possible to have another PowerBI files that contains all the KPIs in it?

 

 

Need Help

2 Replies

  • DataNinja777's avatar
    DataNinja777
    Super User
    1 year ago

    Hi areias_br ,

     

    Yes, you can consolidate KPIs from multiple Power BI files into a single Power BI file. Here’s how you can achieve this, leveraging DAX Studio.

     

    To bring all KPIs into a single Power BI file:

    1. Data Source Consolidation:
      • Identify common tables across all Power BI files (e.g., Calendar Table, Vessels Name).
      • Ensure these tables are consistent in structure and logic.
      • Import these common tables into the new consolidated Power BI file.
    2. Export Measures Using DAX Studio:
    • Connect DAX Studio to your Power BI file.
    • Run the following query to list all measures:
      • Open each Power BI file containing the KPIs.
      • Use DAX Studio to export the measures:
    EVALUATE ROW("Measure Name", [Measure Name])
        • Alternatively, export all measures in bulk:
          • Go to the Advanced Tab in DAX Studio and click Export Measures.
          • Save the measures as a .json or .txt file.

    3. Reimport Measures:

      • Copy the exported DAX formulas and recreate them in the consolidated Power BI file.
      • Make sure to adapt the formulas to work with the consolidated data model.

    4. Optimize Relationships:

      • Establish relationships between common tables and any new data sources required for the KPIs.
      • Validate that the measures calculate correctly in the consolidated file.

     

    Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Thanks for the reply from DataNinja777.

     

    Hi areias_br ,

     

    We can install the external tool Tabular Editor, open the two .pbix files and Tabular Editor, provided that the new file needs to have the same model in it as in the file being copied.

     

    Then follow the steps below:

    Select all measures from the list you want to copy.
    Copy the measures. Press Ctrl+C.
    Switch to the second instance of Tabular editor(one that’s not having measures)
    Select the destination table to store the measures.
    Paste the measures. Press Ctrl+V.

     

    Here are the relevant links:

    Power BI > How to easily copy Measures from one pb... - Microsoft Fabric Community

    Copy Measures Between 2 Power BI PBIX Files - Excelerator BI

    Solved: Is it possible to copy data model or bulk copy mea... - Microsoft Fabric Community