Forum Discussion
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 c...
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.
Saved my life. Thx.