cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
WSwanson Frequent Visitor
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
v-yulgu-msft Super Contributor
Super Contributor

Re: Row-Level Security with Direct Query (not SSAS)

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.
WSwanson Frequent Visitor
Frequent Visitor

Row Level Security (assigning to roles) with Direct Query to a SQL Database (Non-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 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?
2 REPLIES 2
WSwanson Frequent Visitor
Frequent Visitor

Row Level Security (assigning to roles) with Direct Query to a SQL Database (Non-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 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?
v-yulgu-msft Super Contributor
Super Contributor

Re: Row-Level Security with Direct Query (not SSAS)

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.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 105 members 1,398 guests
Please welcome our newest community members: