Direct Query and Dax

[Anonymous]

Hi, is there a list of DAX that works or doesn't work while in DirectQuery Mode? To me, it doesn't seem like a difficult list to have, and it seems that the only way you know for sure is to attempt to use the DAX you want and if it fails, you have to wonder if it was because the fuction is unavailable or you made a mistake.

Is there a list that exists anywhere?

[Anonymous]

Thank you very much. There's alot to look at but it looks like it does have a section that I'm looking for.
Appreciate!

[Shahfaisal]

Start here - https://blog.crossjoin.co.uk/2017/05/09/dax-functions-directquery-and-unrestricted-measures/

[Anonymous]

Thanks for including the link.
The document in the link includes outdated information, particularly the checkmark option. Since it is no longer included in the latest version (Feb 22 for me), is there an equivalent option that replaces that, where would be located?

[DataInsights · Accepted solution]

@Anonymous,

Click the "Download Now" button at the link below to access the white paper:

https://www.sqlbi.com/whitepapers/directquery-in-analysis-services-2016/ 

[Anonymous]

Thank you. Do you know if there is a more recent version of this