cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
egoli55
Regular Visitor

Is it possible to choose what role level access when using Power BI live connection to Tabular Model

Hi,

I have a Tabular Model with Different roles level security (i.e Role_Admin, Role_HR, Role_Employees, etc) defined in the cube Role Level manager. There are multiple dashboards built that uses live connection to access the Tabular Model and there are situations where a single user is added to more than one dashboards. Now, when such a user logon to each dashboards, he/she is seeing all data based on the highest level of access that was granted.

Is there a way to explicitly specify what defined role level name for Power BI dashboard to use when connecting to the Tabular Model?

If that is not possible, are there other ways to specify what role name for Power BI report to use when it connects to the Tabular Model, whether at Desktop design level or in Power BI Service?

Please, i need urgent assistance with this.

 

Thank you!

1 ACCEPTED SOLUTION

thanks for your explanation, @egoli55 

-

Personally speaking, if user has access to Model data via multiple roles, then the user will have access to data based on RLS with higher access, and there's no work-around.

Unless you set single access for each local role, then map user names to specified local role for each dataset on service. That is, separate different permissions into multiple roles, and ensure that one role one permission.

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
egoli55
Regular Visitor

Hi v-xiaotang,

 

Thank you for your response. The article referenced is spot on how to implement row level security and data access gateway. These are already in place in our current data access provisioning in reports. However, recently, we decided to create multiple row level security  roles in Tabular model and each role points to its own unique AD group. The challenge is, we have some users who belong to different AD Groups, which also means they can have access to Tabular Model data via multiple roles in the row level security. For such users, we are noticing they are having access to data based on their row level security with higher access. 
My question is, is it possible to make Power BI explicitely choose a specific row level security role defined in the Tabular Model? If not, are there any work-around on this?

I hope I have been able to explain this better.

Thanks again for your assistance.

thanks for your explanation, @egoli55 

-

Personally speaking, if user has access to Model data via multiple roles, then the user will have access to data based on RLS with higher access, and there's no work-around.

Unless you set single access for each local role, then map user names to specified local role for each dataset on service. That is, separate different permissions into multiple roles, and ensure that one role one permission.

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thanks v-xiaotang,

Now that i know what i was trying to achieve is not possible, I will try some other approach without defining multiple RLS.

v-xiaotang
Community Support
Community Support

Hi @egoli55 

you can use Map user names on specified dataset to achieve this goal.

The content of official tutorial is very detailed, so I attach the link directly. if you need more help, please let me know.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas#user-n...

two videos in this tutorial are also helpful to help understand <Map user names>.

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors