Row Level Security in Tabular Model

Babu Kumar 61

Hi,

We have a Tabular Model structured to store data from multiple entities in AAS Tabular Model. All tables will carry an Entity Code to identify the Entity Data. We have users belonging to different entities and they can see only the data from their own entities which we were able to achieve using User table with corresponding entity code and Row Level Security filter based on this user table.

We also have superusers who can view all entities but only one entity at a time. This is were we end up with problem. We're not able to filter all the tables by entity code for the current selected entity (or a default entity if nothing selected) in the Entity Table. This Entity table is a standalone table without any relation to any other tables in the model. Please Help.

Thanks.

HarithaMaddi-MSFT 10,136 Reputation points

2020-09-11T12:42:35.39+00:00

Hi @Babu Kumar ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

The requirement seems more on controlling or limiting the results rather than restricting the access to the entities for super users. Please suggest if there is any reporting tool on top of the tabular model used and the reason for not implementing the same there as it will be more appropriate. I will work with product team to understand if there is any approach feasible to implement this in tabular model. I will get back to you once I get more insights from them.

Thanks for your patience!
Babu Kumar 61 Reputation points

2020-09-11T14:23:58.943+00:00

Hi @HarithaMaddi-MSFT ,

We are using PowerBI and Excel as reporting tool. We would like to restrict the view by filtering for a specific entity in the Entity table. But that table is standalone because we cannot create a relationship from that table to all the other tables. That is the reason I was trying to see if this can be achieved through RLS based on the selected value from the entity table.

Thanks.

Accepted answer

HarithaMaddi-MSFT 10,136 Reputation points

2020-09-14T10:14:38.59+00:00

Thanks @Babu Kumar for sharing additional details. I got an update from Product team that it is not possible to implement in tabular model and they suggested to do the same in reporting. I can think of adding a single select entity filter to super users to restrict their ability to view one at a time and using different report view for various users by using bookmarks. I would recommend you to post in Power BI technical forums as well for expert ideas to implement it in reporting.

Hope this helps!
Please sign in to rate this answer.
HarithaMaddi-MSFT 10,136 Reputation points

2020-09-15T08:17:15.063+00:00

Hi @Babu Kumar ,

We have not received a response from you. Please let us know if above answer clarified the question, if not, we will continue to engage with you on the issue.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

HarithaMaddi-MSFT 10,136 Reputation points

2020-09-16T08:49:42.567+00:00

Hi @Babu Kumar ,

We still have not heard back from you. Following up to check if above answer helped you, for more queries, please let us know and we will be glad to assist.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Row Level Security in Tabular Model

0 additional answers

Your answer