SSAS Roles and Power BI Services

Question

I did the implementation of roles and security on the SSAS multidimensional mode by implementing roles within the Analysis Services model.&nbsp;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.&nbsp;&nbsp;The connection between SSAS and Power BI is Live connection.&nbsp;&nbsp;I found just a documentation of this but for the tabular mode. (&nbsp;Tutorial: Dynamic row level security with Analysis services tabular model) .&nbsp;Please help,&nbsp;&nbsp;Regards&nbsp;&nbsp;

anonymous · Accepted Answer

Hi&nbsp; Unesoo&nbsp;&nbsp;,&nbsp;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.htmlhttps://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&nbsp;Best Regards,Liu YangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

SSAS Roles and Power BI Services

2 Replies

Related content

Workspace Role

Power bi service

Power BI Service error

Power BI service

Role Level Security