Forum Discussion
Convert storage mode from direct query to import, data source as power bi datasets
Hi Anonymous ,
You can go to Power BI Desktop, go to Model view-->Advanced and change the storage mode from DirectQuery to Import .Similar issue is also resolved in this particular community post . You also follow that post :
https://community.powerbi.com/t5/Desktop/How-to-change-direct-query-to-import-query/m-p/100996Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Hi Anonymous ,
You can go to Power BI Desktop, go to Model view-->Advanced and change the storage mode from DirectQuery to Import .
Similar issue is also resolved in this particular community post . You also follow that post :
https://community.powerbi.com/t5/Desktop/How-to-change-direct-query-to-import-query/m-p/100996
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Hi pratyashasamal , Thank you for your reply.
The option to change storage mode is greyed out for me (please see my original post for a screenshot of what I mean.) Do you know any possible reasons that can cause this and if there are any ways to change this? Thank you!
Hi Anonymous ,
When Power BI Desktop detects an incompatible configuration, it may disallow the change .
Can you please let me know what is the datasource ?
Thanks ,
Pratyasha SamalHi pratyashasamal ,
The data sources I am trying to switch to import mode are power bi datasets.
Thank you.
Hi Anonymous ,
The datasource may be excel , sharepoint , web , etc . What is it ?
Thanks ,
Pratyasha