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)