Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to change one table direct query to import

Hello,

I have a really big data model and I want to change one table which is defined as Direct Query to Import mode.
As far as I know I can change it by clicking right bottom of the report and change direct query to import but it is designed for "all" tables. 
I just need to change one table.

How can I do that?

Thanks in advance

Need Help
Show and Tell
Tips and Tricks
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    Anonymous ,

     

    Go to Relationship View --> Select required table --> go to properties pane --> under Advanced option --> Storage Mode --> change to direct to import or vice versa (Screen shot is attached)

    Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

    Based on your description, it is available to operate as follows.

     

    You can choose ‘Model View’ in the left pane, select the corresponding table using ‘DirectQuery’ storage mode, go to ‘Properties’, change the storage mode from ‘DirectQuery’ to ‘Import’. 

     

    Best Regards,

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

8 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    Anonymous go to relationship tab, and choose table and in property section you can change storage mode

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      6 years ago

      Anonymous ,

       

      Go to Relationship View --> Select required table --> go to properties pane --> under Advanced option --> Storage Mode --> change to direct to import or vice versa (Screen shot is attached)

      Don't forgrt to hit THUMBS UP and Accept this as a solution if it helps you!

      • MohammadGhaheri's avatar
        MohammadGhaheri
        New Member
        3 years ago

        Hi, How can I switch in Power Bi Desktop RS ??
        Advanced Option is not available there!

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, Anonymous 

    Based on your description, it is available to operate as follows.

     

    You can choose ‘Model View’ in the left pane, select the corresponding table using ‘DirectQuery’ storage mode, go to ‘Properties’, change the storage mode from ‘DirectQuery’ to ‘Import’. 

     

    Best Regards,

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • spsp's avatar
    spsp
    Frequent Visitor
    3 years ago

    Hi, I found there is no 'Drect Query' option available, is this convert from import to direct query function removed from powerbi?