Forum Discussion
Advocate IHow to convert to direct query mode
Hello,
I have some tables in my data model, i want to change them to direct query mode at once, is there any way we can do it at once and don't have to change it one by one
Hi patidar_d10, Hope you are doing well.
You can achieve this with the help of TMDL View, Update the mode to direct query for all the tables and click on apply button.
I have created a video on the same topic please check: https://youtu.be/g3iS8kas5Qw?si=LLaqW_-QLw69u3H7
If this post helps to answer your question, please consider accepting it as a solution so others can find it more quickly when they face a similar challenge.
Proud to be a Microsoft Fabric community super user
Let's Connect on LinkedIn
Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.TMDL View:
View → TMDL → Edit table → storageMode = directQuery
Limitations:Mixed modes create composite models
Relationships may break → recreate
Some DAX won't work in DirectQuery
2 Replies
- anmolmalviya05
Super User
Hi patidar_d10, Hope you are doing well.
You can achieve this with the help of TMDL View, Update the mode to direct query for all the tables and click on apply button.
I have created a video on the same topic please check: https://youtu.be/g3iS8kas5Qw?si=LLaqW_-QLw69u3H7
If this post helps to answer your question, please consider accepting it as a solution so others can find it more quickly when they face a similar challenge.
Proud to be a Microsoft Fabric community super user
Let's Connect on LinkedIn
Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates. - Kedar_Pande
TMDL View:
View → TMDL → Edit table → storageMode = directQuery
Limitations:Mixed modes create composite models
Relationships may break → recreate
Some DAX won't work in DirectQuery