Forum Discussion
Direct Query allowed functions
Is there a list of functions allowed in direct query?
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.
7 Replies
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 ZhangNot all functions can be used; the DAX PATH function cannot be used in DirectQuery models.
- ankitpatira
Community Champion
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 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!
I have the same issue. The above option is not available.
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:
How this is helpful to someone.
