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!

0

RLS security does not apply on exported data when tested by role in Power BI Service

Hello Team,

 

Please log the following bug.

 

We have noticed that when RLS security is applied in a report and published on service, to test it we use the Test By Role option present under Datasets > Security option. 

When the report opens, it perfectly applies the security, however, when you export the data from visual, the exported data contains all the rows present in the dataset, thus completely ignoring the security mechanism.

 

Here is an example to repro this.

 

I have following sample dataset:

 

Capture.PNG

 

Now, my email address which is obfuscated has access to India Geo only.

When I go to Power BI Service, datasets > Security > Test By Role, the report loads fine showing only one entry of mine i.e for India role.

Capture.PNG

 

Now, when I export this data in excel, it gives me all the rows as original dataset which is totally blowing up the security part.

 

Capture.PNG

 

Please bring this into the notice of the Dev Team. This feature is very important for our customers to test security in reports before sharing sensitive data out. However, these kind of flaws really drop the confidence in them for this product.

-Prateek Raina

 

 

 

 

 

Status: Delivered
Comments
v-yuezhe-msft
Employee

@prateekraina,

Do you export summarized data from the visual? I create a rls role using username() function and export data in Power BI Service, RLS is not ignored. How do you create the RLS role in your PBIX file?
2.PNG1.PNG

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Needs Info
 
prateekraina
Memorable Member

Hi @v-yuezhe-msft,

 

I am afraid that you have missed the whole point of the issue I am speaking about.
This bug appears when you test the report using"Test as Role" feature present under Dataset > Security.

 

See below screenshots:

Capture5.PNG

Capture4.PNG

 

Capture3.PNG

 

As requested, I have created two roles:

1. India - [Geo] = 'India'

2. US - [Geo] = 'US'

 

Refer

below screenshots:

 

India

Capture1.PNG

 

US

Capture2.PNG

 

Then I added my email address to India role.
Now when you use Test as Role feature and choose India as the Role, I do see a single row which is perfect. However, when I export the data from that visual all the rows are displayed.

 

I hope you can now repro this issue. Let me know in case any other information is required.

 

-Prateek Raina

 

v-yuezhe-msft
Employee

@prateekraina,

I can reproduce this issue, I will consult this issue internally.

Regards,
Lydia

v-yuezhe-msft
Employee

@prateekraina,

I got response from PG:

"This is by design. It is just to test the role but not to apply the same filter for exporting."



Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Delivered
 
Anonymous
Not applicable

I too have a same issue, in this case export to CSV will show you the results (limit 30K lines) with RLS applied wheras the export excel is overiding this RLS filters in the results.

Please advise how the RLS filters can also be applied to export to excel file (150K lines)

GuyInACube
Employee

Interesting. Of note, it looks like you are doing all of this within Power BI Desktop. I don't know if the test by role applies to exporting functionality within Power BI Desktop. The real test is the Power BI service. The only thing i would consider, when in Power BI desktop, is the report itself. For testing other elements, you would want to do this from the Power BI service.

candicehan
Frequent Visitor

I have the same issue. Is this problem fixed? The problem exists in power BI service.

AgTooOldForThis
Frequent Visitor

I confirm the same problem exists while testing in PBI service as well.