How do I check that Row Level Security, as applied in Power BI, is working for Analyse in Excel pivot tables? I have tried changing the user that I am signed in to Excel as, but that doesn’t seem to make any difference.
In fact, my Excel defaults to my personal outlook.com user and despite the fact that this user has no permissions to anything on the corporate xxxx.com domain, the Analyse in Excel pivot tables (and Cubevalue formulas) bring back data. I am using my own PC, which I log into with an account that is not my corporate xxxx.com account. It is a mystery to me why Excel lets me anywhere near the corporate data.
RLS roles have been created in the models that I am using in PBI Desktop then corporate AD groups, which my personal account is not connected to, assigned to each of the roles in the Service. These files should be locked down. It’s convenient, but worrying, that I have access.
Apologies if this post did not end up in the right category. There didn’t seem to be one that was a great fit.