Forum Discussion
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?
- Anonymous3 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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AnonymousNot 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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Ah sad, not exactly what im looking for but ill try the workarounds. Thank you 🙂