Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i have developed SSAS cube with user role.but when i use ssas analysis service in powerbi with live connection.
the report does not show proper data based on user roles.
so please resolve my issue as soon as possible.
Hi @kinjalgshah87,
Current power bi not support add role level security on live connection datasource.
For your requirement, I'd like to suggest you to use SQL Server Data Tools (SSDT) to add RLS on AS side.
Reference link:
Tutorial: Dynamic row level security with Analysis services tabular model
Notice: above tutorial is for AS tabular, I'm not so sure if it also works on AS cube mode.
Regards,
Xiaoxin Sheng
How I can do this with a project in multidimensional mode, I defined roles at SSAS level and I tested them at SSMS level but it does not work at Power bi level, all users can see all data, help please.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |