RLS management - Power BI Dashboard Sharing & Analysis Service Tabulare cube

[Anonymous]

Hello Everyone!

I have a very unusual problem. I have a dashboard to share with a large number of users. This dashboard is connected to an Analysis Services tabular cube on which we have Row Level Security that works well. With these security roles, each user has access to the data of their country. The problem is that I have a dashboard to share with several users, the challenge is:

1- I do not want to apply these roles to this dashboard because we would like users to be able to see the figures of other countries in order to be able to compare themselves.

2- I must give access to users that I cannot add to the security roles (compliance with the Data Privacy rules)

My question is how to share this dashboard by bypassing the roles of the cube analysis services ?

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

We can't define roles within Power BI Desktop for Analysis Services live connections and we need to do that within the Analysis Services model.

I'm afraid the only way  is to add users as members with edit permissions in the workspace . Rls does not work for them.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.