Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to 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!
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.
Hi, I found there is no 'Drect Query' option available, is this convert from import to direct query function removed from powerbi?
it depends on your source for the data @spsp
Proud to be a Super User!
Saved my life. Thx.
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.
@Anonymous go to relationship tab, and choose table and in property section you can change storage mode
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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!
Thanks for this! I struggled to find a answer to this for ages.
Hi, How can I switch in Power Bi Desktop RS ??
Advanced Option is not available there!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |