cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KeesKuip Frequent Visitor
Frequent Visitor

import data from other pbix-file into the current one. Is it possible?

Is it possible to import the (some) data of one pbix file into another one?

 

I want to 'get data' from a pbix-file when I click on 'New Source' in the query editor.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: import data from other pbix-file into the current one. Is it possible?

Hi @KeesKuip,

 

In Power BI Desktop, it's not supported to get data from an existing .PBIX file directly via Get Data option.

 

However, we can get another .PBIX file data in a new .PBIX file use below two methods:

 

a. Use Copy Table option to copy all table data. Then in a new .PBIx file, click Enter Data option, paste the table.

 

z1.PNGz2.PNG

 

b. Export data from visual to a .CSV file. Then in a new .PBIX file, retrieve data from this .CSV file via Get Data->CSV. For more information, please refer to this article: Export data from Power BI visualizations.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Moderator v-qiuyu-msft
Moderator

Re: import data from other pbix-file into the current one. Is it possible?

Hi @KeesKuip,

 

In Power BI Desktop, it's not supported to get data from an existing .PBIX file directly via Get Data option.

 

However, we can get another .PBIX file data in a new .PBIX file use below two methods:

 

a. Use Copy Table option to copy all table data. Then in a new .PBIx file, click Enter Data option, paste the table.

 

z1.PNGz2.PNG

 

b. Export data from visual to a .CSV file. Then in a new .PBIX file, retrieve data from this .CSV file via Get Data->CSV. For more information, please refer to this article: Export data from Power BI visualizations.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
zenodidone Frequent Visitor
Frequent Visitor

Re: import data from other pbix-file into the current one. Is it possible?

Hi everybody

 

this looks good with a reasonable amount of data but im working with a huge Database, I'm not able to perform both of this solutions, any further ideas?

 

Many thanks for your support

 

Kind regards

amien Member
Member

Re: import data from other pbix-file into the current one. Is it possible?

This is still not possible right in PowerBI? I really would like to import PBIX files into other PBIX files. 

zoehyang Frequent Visitor
Frequent Visitor

Re: import data from other pbix-file into the current one. Is it possible?

I have the same problem. My table has 7000 rows and can't do a " copy and paste"

Highlighted
joakims Frequent Visitor
Frequent Visitor

Re: import data from other pbix-file into the current one. Is it possible?

You can publish the old data model to Power BI Service and connect to it through PBI Publisher for Excel. Then, import data to your new data model from this Excel. Hope this helps!

 

Best,

Joakim