RLS and Data Gateway change

[fbouckaert]

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)'

[Ailsa-msft]

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 · Accepted solution]

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

[Ailsa-msft]

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.