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 , thank you for your reply!

 

I want to convert from direct query mode to import mode, which you mentioned is possible. Could you advice on how to do so? 

pratyashasamal's avatar
pratyashasamal
Memorable Member
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 , 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!

    • pratyashasamal's avatar
      pratyashasamal
      Memorable Member
      3 years ago

      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 Samal

       

      • 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.

  • mikemagill's avatar
    mikemagill
    Helper I
    2 years ago

    Has anyone identified a solution to the original poster's problem, which I too am experiencing?

     

    I am connected to two Semantic Models and then am using calculated tables to further manipulate the data.  I can publish the report but it warns me that it will not refresh.

     

    I thought by changing to import mode I would not have this problem but there is no option.

     

    Any help would be appreciated.