Hi Everyone,
I am brand new to databricks and am setting up my first Semantic Model with RLS and have run into an unexpected problem.
When I was testing my model with filters applied (where the RLS would handle later on) it runs extremely fast. I look in Query History and I can see the where statement for my filter being applied (which hits a partition) and returns information extremely quickly. Like in 2 seconds. We are using a serverless connection.
However, when I setup my RLS in Power BI and then click "view as" and look at the exact same information it takes 12-30 seconds to return. I go into query history and the queries power bi is sending for RLS are so long that databrikcs doesn't show me the end where the where statemet should be (and the RLS filter).
I'm assuming RLS isn't being applied on the server level.
Can someone tell me what is going on? PBI documentation states that it appends a where statement when it sends the statement on. But this doesn't appear to be happening. Is this a bug? Or do I need to do something special?