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
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for 123abc's concern about this issue.
Hi jmerencilla ,


What actions did you perform that resulted in seeing the storage mode disabled in the model view?

I tried the following steps to reproduce your problem.
When I connect to the semantic model (Direct Query) from Power BI Service in Power BI Desktop, instead of seeing the storage mode in the model view it is as follows.


Then, I clicked Make Changes to this model in the lower right corner to add the Direct Query connection to the data source.

 

Then, the issue you described appears.

 

Are the above the right steps to reproduce your problem?

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.

  • jmerencilla's avatar
    jmerencilla
    Helper I
    1 year ago

    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.