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...
Eric_Zhang
Microsoft Employee
Microsoft EmployeeAre 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.