Forum Discussion
Online semantic model - import mode
Hi JS23 ,
First of all, my suggestion is not to use the default semantic model, there is a lot of problems with that specially because of the auto update that it gets when you add new tables, and all sort of things. I would create a new semantic model from the lakehouse and recreate the relationships and measures, you can do this using tabular editor or ALM toolkit to make it faster (XMLA needs to be turn on).
If you are using the model connecting to the Lakehouse this should be using the Direct Lake mode, except if you are hitting the guardrails of your capacity please refer to the image below
https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview
The Direct Lake mode is also possible to edit using the Power BI desktop and the update is direct in the service and desktop, once again you need to have the XMLA turned on.
This model is very similar to import mode, so if you are having very slow reports something is happenning.
Altough if you still want to create an import model from your Lakehouse, and you can even get that imported model to be updated online however those updates online won't be automatically, done on the desktop version you have, for this you need to use an external tool like ALM Toolkit that allow you to do the merge between two different dataset's and that way you can have the changes matching.
Hi JS23 ,
First of all, my suggestion is not to use the default semantic model, there is a lot of problems with that specially because of the auto update that it gets when you add new tables, and all sort of things. I would create a new semantic model from the lakehouse and recreate the relationships and measures, you can do this using tabular editor or ALM toolkit to make it faster (XMLA needs to be turn on).
If you are using the model connecting to the Lakehouse this should be using the Direct Lake mode, except if you are hitting the guardrails of your capacity please refer to the image below
https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview
The Direct Lake mode is also possible to edit using the Power BI desktop and the update is direct in the service and desktop, once again you need to have the XMLA turned on.
This model is very similar to import mode, so if you are having very slow reports something is happenning.
Altough if you still want to create an import model from your Lakehouse, and you can even get that imported model to be updated online however those updates online won't be automatically, done on the desktop version you have, for this you need to use an external tool like ALM Toolkit that allow you to do the merge between two different dataset's and that way you can have the changes matching.