Referencing measures from multiple child Power BI files into a Parent Power BI File

[RichardJ]

Hi,

Apologies if this is the incorrect forum. Can anyone point me in the direction of learning/resources which will help me understand the best way to obtain the values of measures from child Power BI files within a Parent Power BI file (or whatever approach would be best to achieve this if referencing isn't possible.)

Worst case i'd  thought about generating a table of the measure values and manually exporting it to a csv file from (a), (b) and (c) and using these as a datasource in (1) but wondered if there is a better way?

I'd like to find the best way of aggregating the values of measures from (a), (b) and (c) into (1).

Thanks

Richard

Measure Aggregarion

[Anonymous]

Hi @RichardJ ,

According to my understanding, you want to migrate measures to another pbix file, right?

If you’ve got 2 PBIX files with the same models, i.e all tables used in the measures have the same data structure.Then you will need an external tool—— Tabular Editor for this.

Below are the steps to copy measures from one file to another:

• 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.

I believe you can get more hints from these :

How to easily copy Measures from one pbix file to another

Copy Measures Between 2 Power BI Files - Excelerator BI

Batch migration from one pbix file to another pbix

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RichardJ]

Hi @Anonymous,

Thanks for the response. I wasn't aware of the Tabular tool so appreciate the info.

My question was to see if it is possible to reference the measures in (a), (b) and (c) in (1) without having to copy/recreate the measures from (a),(b),and (c) in (1).

As an example, there may be the following measures shown in the following files

From file (a) : Measure 'Status' = 50

From file (b) : Measuse' 'Status' = 25

From file (c) : Measure 'Status' = 25

I'd like to create a calculation in File (1) which enables

Total Status = 'Status' from file (a) + 'Status' from file (b) + 'Status' from file (c)

So the result of Total Status in file (1) would equal 100

That is, reference the data from individual pbix measures from a parent pbix file which aggregates the content of the child files.

Or - if there's another way of achieving this if it's not currently possible to nest several power bi files.

Thanks,

Richard