Forum Discussion

jmerencilla's avatar
jmerencilla
Helper I
1 year ago

Changing Direct Query to Import Storage Mode

Hello everyone.   I am currently connected to a dataset (Direct Query) and to a SharePoint file. Looking at my Model View, I cannot change the Storage Mode because it is disabled. Is there a way to...
Need Help
Show and Tell
jmerencilla's avatar
jmerencilla
Helper I
1 year ago

Hi Anonymous ,

 

Thanks for the alternative solutions, but these will not work for me either. 

 

Regards

jmerencilla

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jmerencilla ,

It's not clear how that semantic model in your service has been modified via XMLA endpoints.


In my testing, I used the deployment pipeline to copy the semantic model (Direct Query) that had been modified by the XMLA endpoint in one Premium workspace to another Premium workspace.
Get started using deployment pipelines, the Fabric Application lifecycle management (ALM) tool - Microsoft Fabric | Microsoft Learn

The PBIX file can then be downloaded from this Premium workspace.
Once the PBIX file is opened, select Discard Changes at the pending changes prompt and change Direct Query to Import.


Please try the above steps.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.