Forum Discussion
Convert storage mode from direct query to import, data source as power bi datasets
Hi Anonymous ,
You can go to Power BI Desktop, go to Model view-->Advanced and change the storage mode from DirectQuery to Import .Similar issue is also resolved in this particular community post . You also follow that post :
https://community.powerbi.com/t5/Desktop/How-to-change-direct-query-to-import-query/m-p/100996Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Adding a comment here because this was the only post I could find on the subject and I hope it helps future searchers. I think semantic models technically use "live connections" and aren't really import or directquery. It does use directquery technology when you combine it with other sources to make a composite, though.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-live-connect-dq-datasets
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
You can get performance issues sometimes if you are combining a semantic model with anything else:
https://www.sqlbi.com/articles/strong-and-weak-relationships-in-power-bi/
In this case I don't think there is any way to do import on a semantic model. This is a good usecase for data flows, however: