SSAS Roles and Power BI Services

[Unesoo]

I did the implementation of roles and security on the SSAS multidimensional mode by implementing roles within the Analysis Services model. 

And it works on SSAS and I tested roles on SSMS , I also did the user mapping in power bi services. But in power bi services, all users can see all data. 

The connection between SSAS and Power BI is Live connection.

I found just a documentation of this but for the tabular mode. ( Tutorial: Dynamic row level security with Analysis services tabular model) .

Please help, 

Regards

[Anonymous · Accepted solution]

Hi  @Unesoo  ,

You can check these links to help you set up RLS for the SSAS multidimensional model:

http://bharathonsqlserver.blogspot.com/2016/07/dynamic-security-in-ssas-in-detail.html

https://diegocampereira.com/2017/08/18/creating-a-dynamic-row-level-security-for-an-olap-cube-multid...

http://bifuture.blogspot.com/2011/09/ssas-setup-dynamic-security-in-analysis.html

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Unesoo]

Hi @Anonymous 

Thank you so much for your answer, I refer to your links to find a solution to my problem, but all points discussed in this articles are done in my project, the problem was in the Power Bi Services Mapping, I change the user mapping from custom data to effective username and it works now.

Thank you very much

Best Regards