Forum Discussion

shona's avatar
shona
Frequent Visitor
10 years ago
Solved

Direct Query allowed functions

Is there a list of functions allowed in direct query?
  • ankitpatira's avatar
    ankitpatira
    10 years ago


    shona I am not aware of any such list but you do have option in power bi desktop to allow unrestricted measures via DirectQuery and that I believe should allow to use most of the functions.

     

     

     

     

     

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago


shona I am not aware of any such list but you do have option in power bi desktop to allow unrestricted measures via DirectQuery and that I believe should allow to use most of the functions.

 

 

 

 

 

  • gomesan1's avatar
    gomesan1
    Frequent Visitor
    4 years ago

    ankitpatira I don't have this option though. Any thoughts on why and workaround?

    I would like to use functions like Trim in DirectQuery mode and I'm not able for the moment.

    Thanks!

    • Mehul's avatar
      Mehul
      Frequent Visitor
      4 years ago

      I have the same issue.  The above option is not available.

    • lovat's avatar
      lovat
      New Member
      2 years ago

      I solved this by adding this line to my oracle query in M

      Where table.field = ' " & Parameter_Name & " '#(lf)

  • YG_MA's avatar
    YG_MA
    Regular Visitor
    2 years ago

    I know this is an old thread but I think the question is still a valid one. As someone new to Power BI, I found myself often spending time on a solution only finding out much later that a particular function is not supported in Direct Query mode. 

     

    It's unfortunte that one cannot find a list of Direct Query allowed functions. However the following link seems to return all Dax function that are somewhat not supported in direct query mode:

     

    https://learn.microsoft.com/en-us/search/?scope=DAX%20formula%20language&terms=%22This%20function%20is%20not%20supported%20for%20use%20in%20DirectQuery%20mode%22&category=Documentation

     

    How this is helpful to someone.