query(1,1) function weekday not allowed as part of calculated column dax expressions on directquery

[hardikkeraliya]

query(1 1) function weekday not allowed as part of calculated column dax expressions on directquery models

[v-jingzhang · Accepted solution]

Hi @hardikkeraliya 

What is your current DAX expression of the calculated column? Which function is used in it?

To avoid performance issues in DirectQuery models, there are several model limitations needing to be considered in advance. Many DAX functions are not supported in DirectQuery mode when used in a calculated column. 

And in the document of a DAX function, it may have the following remark. DAX function reference - DAX | Microsoft Learn

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.