Connecting multiple PowerBi Files

[Rollow1234]

Goodday!

I have multiple PowerBi files that all calculate stuff for multiple departments. These files contain their own calculated columns and measures. 

I would like to make a PowerBi file that agregrates some data from all these other files, but i do not see the option to connect to data from other PowerBi files. Is this possible? 

[Rollow1234]

Ah sad, not exactly what im looking for but ill try the workarounds. Thank you 🙂

[v-rongtiep-msft · Accepted solution]

Hi @Rollow1234 ,

Unfortunately, it is not possible to directly connect to data from other Power BI files. However, there are a few workarounds that you can try:

1. Import data from the other Power BI files into Excel or CSV format, and then import that data into your new Power BI file.

2. Use Power BI's "Get Data" feature to connect to the data sources that the other Power BI files are using, and then recreate the calculations and measures in your new Power BI file.

3. Use Power BI's "Analyze in Excel" feature to connect to the data in the other Power BI files, and then import that data into your new Power BI file.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details .

Best Regards
Community Support Team _ Rongtie

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