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.

 

 

 

 

 

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.