Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey all,
I am getting a little confused with row level security.
So i understand you can only implement this if you use SSAS is that correct?
I dont understand how this works - so could someone shed some light. If i connect to SQL and make a dashboard and publish it - the data held within will be all the data that i had published as a dash. If i share that to someone they will see all the data.
Now lets say hypothetically - i make a tablular cube. I have full access to the data. Other people have restricted access. So i publish said dashboard - now surely when i do that it will publish with all the data? Then if i share it will not everyone still see the data?
OR does it not store the data in the cloud (like if you connect to SQL) and forces a refresh for each person that views the data?
I hope this makes sense,
Dan
Solved! Go to Solution.
Hi Dan,
You need to utilise the Analysis Services Live Connector for this scenario. You can find more info here:
In this arrangement, no data is stored in the cloud. Power BI converts your request to a DAX query, and sends that query (along with your AD info) to the Tabular model who duely executes the query applying the appropriate Row Level Security.
Hope this helps
Sacha