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

     

brianjwilson's avatar
brianjwilson
Frequent Visitor
2 years ago

I had this issue and was able to work around it. I believe my situation was similar to the original post in that I had a PBIX desktop report with several imported data tables from various sources. I then wanted to get data from a published Power BI dataset and be able to create relationships between that data and the other data within my report. To do this I 1) created a calculated table for each of the Power BI dataset tables I wanted, removing extra columns I wasn't interested in using the SELECTCOLUMNS function, naming each column something unique by simply prefixing the column name with the name of the original table - this is required for a future step to work, 2) created relationships between those newly calculated tables, 3) created a calculated table using NATURALINNERJOIN to combine all of those tables together into one (which will use the relationships for the join conditions and requires unique column names to work in DAX). Now I have an imported table with all of the data from the Power BI dataset that I was interested in that can be used across the other data that has been imported. Hope this helps for you.