Forum Discussion
How to change one table direct query to import
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!
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.
Super UserAnonymous go to relationship tab, and choose table and in property section you can change storage mode
Super UserAnonymous ,
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!
Hi, How can I switch in Power Bi Desktop RS ??
Advanced Option is not available there!Thanks for this! I struggled to find a answer to this for ages.
