How to change one table direct query to import

[Anonymous]

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

[Tahreem24 · Accepted solution]

@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!

[spsp]

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

[vanessafvg]

it depends on your source for the data @spsp  

[ENilox]

Saved my life. Thx.

[v-alq-msft · Accepted solution]

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.

[parry2k]

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

[Tahreem24 · Accepted solution]

@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!

[evan-beierschmi]

Thanks for this! I struggled to find a answer to this for ages.

[MohammadGhaheri]

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