Forum Discussion
Power bi embedded rls complex
Hi All I have watched the following video and got this working great, Summarising what I think is happening, Power BI is smart enough to know the schema and add on the extra where clause using t...
Are you in DirectQuery mode?
Based on my test, in DirectQuery, neither Stored Procedure nor CTE is supported, even when I tried to bypass the limitation via wrapping the recursive CTE in a table valued funtion, it still pops up a window saying not supported. So you can just leave the dataset as simple, then try to deal with hierarchy via DAX.