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

Row-Level Security with Direct Query (not SSAS)

We have set up several reports based on a Direct Query out to a standard SQL database contained on the same server as our instance of the Power BI Report Server. The tables are queried using a Live Connection in Power BI Desktop.

Everything work well and pulls in data properly with all relationships set up within the Power BI Desktop pulling through properly. We are trying to implement Row Level Security with this solution and I am not sure if we are missing something simple or if Row Level Security is not possible with a Direct Query to a SQL Database that isn't a SSAS database (which we are trying to avoid as we prefer to be able to adjust relationships within Power BI Desktop).

We can set up roles properly within Power BI Desktop, and previewing with those roles is something that we are also able to do. The problem is that we cannot find out how to assign users or groups to roles.

We've found many solutions online, but this all apply to versions that are not Report Server. Is this something that is possible? If so, how do we assign users to roles?

 

Thanks for any help

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Microsoft
Microsoft

Hi @WSwanson,

 

For non-SSAS live connection, RLS is not supported in the current version of the Power BI Report Server. 

 

Please see jtarquino's reply here.

 

Best regards,

Yuliana Gu

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

View solution in original post

Highlighted
Frequent Visitor

We have set up several reports based on a Direct Query out to a standard SQL database contained on the same server as our instance of the Power BI Report Server. The reports work well and pull in data properly with all relationships set up within the Power BI Desktop pulling through properly. We are trying to implement Row Level Security with this solution and I am not sure if we are missing something simple or if Row Level Security is not possible with a Direct Query to a SQL Database that isn't a SSAS database (which we are trying to avoid as we prefer to be able to adjust relationships within Power BI Desktop). We can set up roles properly within Power BI Desktop, and previewing with those roles is something that are also able to do. The problem is that we cannot find out how to assign users or groups to roles. We've found many solutions online, but this all apply to versions that are not Report Server. Is this something that is possible? If so, how do we assign users to roles?

View solution in original post

2 REPLIES 2
Highlighted
Frequent Visitor

We have set up several reports based on a Direct Query out to a standard SQL database contained on the same server as our instance of the Power BI Report Server. The reports work well and pull in data properly with all relationships set up within the Power BI Desktop pulling through properly. We are trying to implement Row Level Security with this solution and I am not sure if we are missing something simple or if Row Level Security is not possible with a Direct Query to a SQL Database that isn't a SSAS database (which we are trying to avoid as we prefer to be able to adjust relationships within Power BI Desktop). We can set up roles properly within Power BI Desktop, and previewing with those roles is something that are also able to do. The problem is that we cannot find out how to assign users or groups to roles. We've found many solutions online, but this all apply to versions that are not Report Server. Is this something that is possible? If so, how do we assign users to roles?

View solution in original post

Highlighted
Microsoft
Microsoft

Hi @WSwanson,

 

For non-SSAS live connection, RLS is not supported in the current version of the Power BI Report Server. 

 

Please see jtarquino's reply here.

 

Best regards,

Yuliana Gu

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors