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

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
MinL
Regular Visitor

fabric semantic model

sometime I got confused about the default fabric semantic model. Does this default semantic model contains relationship among tables. Or it just tables without any relationship created --  and this being called the default semantic model. Can someone clarify on this. 

2 REPLIES 2
lyjavier
Frequent Visitor

It depends, you can add your desired tables to the default semantic model, config relationships between them.

The difference would come into the picture in your Power BI Report:

- If you connect to the lakehouse/warehouse with mode Direct Query: You can select the tables you want, then customize the relationships in Power BI Model View

- If you connect to the lakehouse/warehouse with mode Direct Lake (Live Connection): that means you will get the exact data model which is the default semantic model you already had in Fabric. For example: You have tables product and sale with a relationship, you will have the exact same thing after connect to this default semantic model in Power BI Desktop and you are not able to update anything like: update column, change relationship type,..

 

Hope this answer addresses your question!

Hi @MinL, I haven't heard about your response for a while.

If you find my answer helpful, then please consider Accept it as the solution to help the other people find it more quickly in case they face the same issue or have the same question as you.

Thank you!

Helpful resources

Announcements
Sept Fabric Carousel

Fabric Monthly Update - September 2024

Check out the September 2024 Fabric update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

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