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

RLS and Data Gateway change

We had Power BI Gateway set up to an on-premise SQL Analysis Services.
Roles are defines on the SSAS, and user mapping is set in PBI Gateway.

everything worked, user created new reports  using datasets from other reports.

we move the SSAS to another on premise server recreated the gateway datasource.
redeployed the original reports (replacing the datasets)

Opening reports connected to a dataset, used only in that report, is successfull.
 But when I try to open a report using a shared dataset, it gives me the error 'The report can't be viewed because the underlying dataset uses row-level security (RLS)'

1 ACCEPTED SOLUTION
fbouckaert
Frequent Visitor

I removed 1 link and added it again to 1 shared dataset, and all started to work

 

View solution in original post

3 REPLIES 3
Ailsa-msft
Community Support
Community Support

Hi @fbouckaert 

I am so glad to hear that you have solved your problem . Please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regard

Community Support Team _ Ailsa Tao

fbouckaert
Frequent Visitor

I removed 1 link and added it again to 1 shared dataset, and all started to work

 

Ailsa-msft
Community Support
Community Support

Hi @fbouckaert 

So did you have access to the shared dataset ? Please check the user mapping for the shared dataset to judge whether you have the permission to access the dataset .

 

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors