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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi pratyashasamal ,

 

The data sources I am trying to switch to import mode are power bi datasets.

Thank you.

pratyashasamal's avatar
pratyashasamal
Memorable Member
3 years ago

Hi Anonymous ,
The datasource may be  excel , sharepoint , web , etc . What is it ?
Thanks ,
Pratyasha 

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi Anonymous , 
    Another way can be :-

    • Look at the status bar on the right side.
    • Click on “Storage Mode: DirectQuery (Click to change)” as shown below.
    • Click on “Switch all tables to Import mode“.

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi pratyashasamal ,

       

      My storage mode is not clickable, and doesn't have the "(Click to change)" option.

      Please note that the report contains other tables from other sources, such as excel files from sharepoint folder. These are already in import mode - hence "Storage Mode: Mixed" in the screenshot. 

      • pratyashasamal's avatar
        pratyashasamal
        Memorable Member
        3 years ago

        Hi Anonymous ,

        Can you see something like this in Query Editor, Change the Connection Settings to Import Mode.
        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