Clarification Needed: Time Intelligence DAX Won't Work in RLS?

yyzheng12 — Wed, 21 Dec 2022 16:49:33 GMT

I'm reading up this statement in almost all time intelligence DAX tutorials.

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Does it mean that all time-intelligence DAX won't work in a visual if an RLS rule is implemented on top of it?

Thanks!

Re: Clarification Needed: Time Intelligence DAX Won't Work in RLS?

v-jianboli-msft — Wed, 28 Dec 2022 06:55:12 GMT

That statement means : If you are using Direct Query Mode or RLS, you cann't use the Time Intelligence function in the DAX expression of RLS rules or calculated columns.

For more details, please refer to:

DirectQuery in Power BI - Power BI | Microsoft Learn

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Clarification Needed: Time Intelligence DAX Won't Work in RLS? in DAX Commands and Tips

Clarification Needed: Time Intelligence DAX Won't Work in RLS?

Re: Clarification Needed: Time Intelligence DAX Won't Work in RLS?