Direct Query allowed functions

[shona]

Is there a list of functions allowed in direct query?

[v-yuezhe-msft]

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]

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

[ankitpatira · Accepted solution]

@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]

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%20...

How this is helpful to someone.

[gomesan1]

@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!

[lovat]

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

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

[Mehul]

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