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