Forum Discussion
Changing Direct Query to Import Storage Mode
hi Anonymous
I appreciate the help. Thank you!
There are no other actions done that resulted in this behavior. In fact, I created a blank PBI, connect it to the semantic model, and automatically, it is disabled. I am not able to change.
I also created another blank PBI, connect it to a CSV file first, and connect it to the same semantic model. Storage model now is Mixed, but still disabled.
In my other project, I am able to see this "Make Changes to this mode". But from Live connection, it only goes to DirectQuery.
What I need, if possible, is from DirectQuery to Import. But based on my readings, is only available when you are not connected to a semantic model like SQL server or Analysis Services.
My goal is, if I can import the data from the semantic model, then our reports will be faster because it is not pulling the data directly from the service.
Hi jmerencilla ,
Have you tried downloading PBIX files from this semantic model.
Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn
In this PBIX file, the storage model can be changed from Direct Query to Import.
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.