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

[Lora9999]

Hello,

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?

 

[Anonymous]

Hi, @Lora9999 

Thanks for the reply from danextian and PijushRoy. Here is another way to change the connection mode.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[danextian]

Hi  @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  on to  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]

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.

[Lora9999]

[PijushRoy]

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

[Lora9999]

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