fabric semantic model

[MinL]

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. 

[lyjavier]

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!

[lyjavier]

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!