Import table from another PBI model

Question

Hi&nbsp;I am in a situation where I need to import one table from another PBI model. The table is built from several data sources and I would hate to import it all and redo all the queries to make a duplicate.&nbsp;I don't see why it shouldn't be possible to just point to that table and import it to my other model? But how??&nbsp;&nbsp;

anonymous · Answer

Hi Maggie&nbsp;I have access to recreate the data, but I just find it easier to reuse the queries I already have made in the other model. It is one table created from a total of 15 different queries sourcing from a number of different tables and doing a lot of quite advanced stuff.So I would spare myself the trouble of bringing all the queries into my other model if I could just get the resulting table. Having the queries dublicated would also mean that I&nbsp; would have to maintain them in two different models, instead of just one.&nbsp;Does it make sense?

anonymous · Answer

Hi&nbsp;I am in a situation where I need to import one table from another PBI model. The table is built from several data sources and I would hate to import it all and redo all the queries to make a duplicate.&nbsp;I don't see why it shouldn't be possible to just point to that table and import it to my other model? But how??&nbsp;&nbsp;

v-juanli-msft · Answer

Hi&nbsp;Anonymous&nbsp;
It is impossible to import data from another power bi file.
&nbsp;
You could publish power bi to Power BI Service, then connect to Power BI service dataset with Power BI Desktop, but in this way, it is a live connection.
&nbsp;
Best RegardsMaggie
&nbsp;
Community Support Team _ Maggie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi Maggie&nbsp;Thanks for your reply.&nbsp;I am aware of that possiblility, but does it mean I can't import it to a model with other data (which is the present usecase)?&nbsp;Best,Lars

v-juanli-msft · Answer

Hi&nbsp;Anonymous&nbsp;Could you tell more about your scenario?&nbsp;For example, i download a pbix with some data i'd like very much.But i have no access to the data sources this file use,&nbsp;thus, when i open the Edit queries, i can't see data and steps applied.&nbsp;I have another pbix file with my data, i want to load data from the pbix above.&nbsp;Is my assumption right?If not, please illustrate your scenario with more details.&nbsp;Best RegardsMaggie&nbsp;

Forum Discussion

Import table from another PBI model

7 Replies

Related content

Why imported table from onelake is black?

call/import a notebook into another notebook in fabric

Power Query LookUp in another table

[PowerQuery] add (same) column from another table

Import Date in Power BI Table