Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Jurgen1978
Regular Visitor

Importing Tabular Model in PowerBI Dektop

Hi everyone,

 

I have an issue, importing a Tabular Model into Power BI Desktop. I have read about similar questions within this forum, however I think my question is slightly different:

 

I have made a Tabular Model, in which I inserted some tables with relevant data. Within the model, we created some relations between the different tables. 
I want to import this Tabular Model into Power Bi, keeping the relations that we have created in the original model. However, when I import the Tabular Model, I lose the relations that I created, thus getting different results, in relation to the results that I obtain, when I extract the results directly from the Tabular Model (which is the option Live Connect)

 

I do need to use the Import option, since the reports that I deliver are published outside my organization, thus not being able to Live Connect with the Tabular Model. 

 

My question is: " is there a possibility to import a Tabular Model in PowerBI, which contains the original relations created within it? If yes: what are the steps to take, to be able to succesfully import the Tabular Model as described above?

 

Thanks for your reply!
Kind regards,
Jurgen van Geest 

 

3 REPLIES 3
Greg_Deckler
Super User
Super User

Is there a reason you can't just recreate the relationships in the Power BI model?

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

Check for auto detect, else you have to do it manually. refer this

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Hi there!

Auto detect doesn't work, since the relations that I established in the Tabular Model, dissapear when I imported the model in Power BI.

 

I could manually re-establish the relations in PowerBI. However, I would prefer not doing so, since there are various reasons to model the  data as close to the source as possible.

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.