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

     

ropebender's avatar
ropebender
Frequent Visitor
2 years ago

These solutions no longer work.

I am not gifen an option to change in the Model View

The Staus Bar does not have the "Change" option

and I even tried the trick of creating a new calculated column.  It let me create one.

I also added a new file and made it Import mode, and I can go to the Tables view and that is the only table that shows up.  The other tables show "Direct Query" on a gray background, and there is no way I have found to change it.

 

Anyone have any additional tricks?

 

Claude Van Horn

 

brianjwilson's avatar
brianjwilson
Frequent Visitor
2 years ago

Try creating a calculated table from the origial direct query table, not just a calculated column. And then use that calculated table for all relationships, visuals, etc. That calculated table will be in import mode.

  • ropebender's avatar
    ropebender
    Frequent Visitor
    2 years ago

    I'm not positive how I can create a calculated table from the Direct Import Table, but even if I could, wouldn't I still have to wait for the Direct Query table to search and load every time I change a parameter?  I'm trying to eliminate the delays caused by the Direct Query.

     

    Am I missing something?

     

    PS.  I figured out how to create a new table from the Direct Import query, but there's not enough resources to do that.

    So I'm still looking 🙂

    Thanks for the help!  

     

    Claude Van Horn

  • BugmanJ's avatar
    BugmanJ
    Helper V
    2 years ago

    If you do this, you cant create a scheduled refresh in PowerBI service sadly