Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.