cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

how to add ssas multidimensional row level security's in power bi

We are adding User's SSAS Multidimensional security but we are login Power BI That particular user not reflecting,
How to solve ?Please let me the issue it's very urgent

1 REPLY 1
Highlighted
Resident Rockstar
Resident Rockstar

Re: how to add ssas multidimensional row level security's in power bi

Hi @kishore249,

 

If you connected to SSAS multidimensional database with live connection, you should define security roles in your SSAS model. The detail steps you could refer to this article.

 

Assuming you have created row level security in ssas multidimensional correctly, you should configure the on-premise Gateway and add data source. It' important for you to note Map user name when you add User.

 

Note: Mapping is for the specific data source that is being configured. It is not a global settings. If you have multiple Analysis Services data sources, you will have to map the users for each data source.

 

If you connected to SSAS multidimensional database with import, you should define the roles in Power BI Desktop. The details steps you could refer to this article.

 

In addition, you could refer to the similar issue below:
RLS with Power BI Embedded and SSAS Multidimensional

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors