Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Import table from another PBI model

Hi   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 d...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

It is impossible to import data from another power bi file.

 

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.

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
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
7 years ago

Hi Maggie

 

Thanks for your reply.

 

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)?

 

Best,

Lars

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi Anonymous 

    Could you tell more about your scenario?

     

    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, 

    thus, when i open the Edit queries, i can't see data and steps applied.

     

    I have another pbix file with my data, i want to load data from the pbix above.

     

    Is my assumption right?

    If not, please illustrate your scenario with more details.

     

    Best Regards
    Maggie

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Maggie

       

      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  would have to maintain them in two different models, instead of just one.

       

      Does it make sense?