Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Connecting multiple PowerBi Files

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? 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

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