Is it possible to restrict SQL query result visibility by column data using RLS

0 votes

Is it possible to restrict SQL query result visibility by column data using RLS?

I have an inventory management application that currently uses SSRS, and passes a user's access level as a parameter to determine what results can be returned. We're trying to start using Power BI instead, but since Power BI doesn't support the passing of parameters through a web application (without using Embedded, anyways, which we can't use), we are trying to implement RLS as a workaround. 

 Is it possible to create a role in RLS that allows a user to only see records with their access level or lower - I.e. based on the data being pulled from the SQL Server database? Most of what I see in RLS restricts visibility on visuals or columns, but I haven't been able to find anything on restricting access to actual data.

Nov 12, 2020 in Power BI by anonymous
• 8,910 points
425 views

1 answer to this question.

0 votes

RLS is on row level, you can create rules and associate users on them (or dynamically)....

Also, depends on what parameters you need, it's possible to use on Power BI Service, but they are static for the users... 

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://community.powerbi.com/t5/Community-Blog/Using-the-Power-BI-Service-Parameters-to-change-conn...

answered Nov 12, 2020 by Gitika
• 65,910 points

Related Questions In Power BI

+1 vote
1 answer

Is it possible to manage limits while using dedicated capacity power bi embedded app service?

These limits are not related to using ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,570 points
540 views
0 votes
1 answer

Is it possible to use R Plotly library in R Script Visual of Power BI?

For newer versions of PowerBI, it's also ...READ MORE

answered Dec 8, 2020 in Power BI by Gitika
• 65,910 points
1,315 views
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,570 points
13,386 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
3,789 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
919 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
76,829 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
18,480 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,180 points
572 views
0 votes
1 answer

Is it possible to use multiple dataset for one report?

Yes, of course, you can load a few ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,910 points
2,111 views
0 votes
1 answer

How to connect webpage data by using Power BI Desktop?

Web connections are only established using basic ...READ MORE

answered Nov 18, 2020 in Power BI by Gitika
• 65,910 points
727 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP