Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)'
Solved! Go to Solution.
I removed 1 link and added it again to 1 shared dataset, and all started to work
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
I removed 1 link and added it again to 1 shared dataset, and all started to work
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.