How to Convert a Power BI Semantic Model from DirectQuery to Import Mode

Question

Hello,&nbsp;II created a dataset with data imported into Odata and Excel imported from Sharepoint.This is stored as a Power BI semantic model.The semantic model has limitations when creating measures or using parameters.I think this is due to DirectQuery.Is there a way to convert the semantic model to Import mode?&nbsp;

pijushroy · Answer

Hi&nbsp;Lora9999&nbsp;Please follow the below steps to Add&nbsp; Columns, Measure, or Inserta&nbsp; new table in the Semantic model which will create a new Semantic model and report with the connection of the existing Semantic modelPlease let me know if not work

&nbsp;
&nbsp;
&nbsp;

lora9999 · Answer

I have tried this approach, but Transform Data is not working.

lora9999 · Answer

danextian · Answer

Hi &nbsp;Lora9999,
To clarify, you connected to a semantic model via direct query and you want to change the storage mode to import? You can create a calculated table referencing the dq table. You will need to toggle data connection&nbsp; on to&nbsp; be able to refresh it in the service. Warning, this can have a serious performance implication depending on the size of the direct query table.

If the semantic model is hosted in a workspace with Premium capacity enabled, you can connect to the model via the Analysis Services connector and can be transformed in Power Query using the workspace's XMLA endpoint.

danextian · Answer

The semantic model has limitations when creating measures or using parameters.
-not all functions are supported in dq. Figuring out which work is sometimes a trial and error
-field parameters must be re-created in the local model.

Forum Discussion

How to Convert a Power BI Semantic Model from DirectQuery to Import Mode

6 Replies

Related content

DirectQuery Semantic Model

Cannot convert from DirectQuery to Import mode

Embedded Power BI composite report – DirectQuery semantic model visuals not loading

Convert DirectQuery Mode to Import

Semantic Model