Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Convert storage mode from direct query to import, data source as power bi datasets

Hi,   Is there a way to convert the storage mode from direct query to import mode without having to delete and redo the entire model?   I have a report where I pull multiple power bi datasets, in...
Need Help
  • pratyashasamal's avatar
    pratyashasamal
    3 years ago

    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

     

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi Anonymous ,

As far as I know, it is not possible to convert import mode to direct query mode, But direct query mode can be converted to import mode

If you really need to change it to direct query,

my suggestion is to create a new one using direct query then copy your applied steps from your previous report.

It will be quite time consuming but it will achieve your requirement.
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

dg123456789's avatar
dg123456789
Advocate III
2 years ago

You aren't even reading the question.