Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
v-srigar
New Member

Row level security limitation on number of roles

Hi All,

 

In one of our PowerbI Report we have configured more than 19 roles under Modeling -> ManageRoles in PowerBI desktop. When I was trying to publish I am able to see only 19 roles under published DataSet in PowerBI service.

 

Is there any limitation on number of roles under Row Level security?

 

 

 

Thanks,

Srikanth

4 REPLIES 4
v-srigar
New Member

Hi All,

 

In one of our PowerbI Report we have configured more than 19 roles under Modeling -> ManageRoles in PowerBI desktop. When I  publish the report I am able to see only 19 roles under published DataSet in PowerBI service.

 

Is there any limitation on number of roles under Row Level security?

 

 

 

Thanks,

Srikanth

v-sihou-msft
Employee
Employee

@v-srigar

 

There's no limitation on number of roles. I haven't reproduced your issue. All created measures can be displayed on Power BI Service.

 

8.PNG

 

What's your data source? And what are your row level filter expressions?

 

Regards,

@v-sihou-msft, One more update is I have tested one more scenario and I am able to reproduce this issue.

 

Repro steps:

 

1. Create PowerBI dashboard with more than 19 roles using PowerBI desktop.

2. Publish PowerBI report to Group work space.

 

Now you can see only 19 Row level security roles.

 

Note: If tried same thing in Myworkspace, I am able to see all the roles(I mean more than 19 roles).

 

Thanks,

Srikanth

Thanks for your reply.

 

My data source is Sqlazure DB View and I just use string filters.

 

Thanks,

Srikanth

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors