Forum Discussion

patidar_d10's avatar
patidar_d10
Icon for Advocate I rankAdvocate I
9 months ago
Solved

How 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
Need Help
  • anmolmalviya05's avatar
    anmolmalviya05
    9 months ago

    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's avatar
    Kedar_Pande
    9 months ago

    patidar_d10 

     

    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

anmolmalviya05's avatar
anmolmalviya05
Icon for Super User rankSuper User
9 months ago

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.