Using a Power BI pbx as a master file

[Anonymous]

Hi,

I am currently running a number of dashboards in different pbx files that use the some of the same foundation tables.

An example is I have a client file that I have to use all the time, currently I copy the table to new pbx files so all the added columns etc are the same.

I have been looking for a way to set up a central pbx file with the "master tables" in so I can link to them, however I cant seem to see a way to link the pbx to see the data between files.

Is this possible ? if so can anyone show me how to do it or pointg me to any articles about it.

Thank you in advance

[v-danhe-msft]

Hi @Anonymous ,

Could you have tried with template file?

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

It may give a template file firstly and you could add other data to it for your report.

Regards,

Daniel He

[Anonymous]

Hi

Thank you for this, I think if I am reading this right is on a report report basis, the thing is the reports will be different may need data from another source.

However this is really good to know and put in practice

Thank you again

[v-danhe-msft]

Hi @Anonymous ,

Yes. If it could help you, don't forget mark one reply as answered to close this topic to let more users know.

Regards,

Daniel He

[Anonymous]

Thank you will have a read

[itchyeyeballs · Accepted solution]

Do you want to use a locally saved pbx file? if so not sure that is possible

This might be of interest though - https://exceleratorbi.com.au/new-power-bi-reports-golden-dataset/

Dataflows also look really promising for centralising data resources

[Anonymous]

Thank you this looks interesting