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.

     

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi shona,

This article lists the supported functions in Power BI Desktop. Reference: DAX basics in Power BI Desktop.

However, a set of above DAX functions have been disabled by default in DirectQuery mode in order to avoid performance issues with these functions. Once you select “allow unrestricted measures via DirectQuery” option as other post, you are able to use all the functions. For more details, please check this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/ .

Thanks,
Lydia Zhang

  • zimme063's avatar
    zimme063
    Regular Visitor
    8 years ago

    Not all functions can be used; the DAX PATH function cannot be used in DirectQuery models.