Forum Discussion

Unesoo's avatar
Unesoo
Frequent Visitor
5 years ago
Solved

SSAS Roles and Power BI Services

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 ...
Data Protection
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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-multidimensional-project-server-2013/

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's avatar
Unesoo
Frequent Visitor
5 years ago

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