Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all!
We have a report that utilizes RLS. Our solution is set up in the following way:
Until recently, there was no issue with this set-up. The only thing we changed was to move the path calculation from one table to another and we made sure that everything is working in Power BI before publishing it to the workspace.
After we have added the Entra group to the permissions (read only) they report that they can't see the report at all and get the following error message:
"The report can't be viewed because the underlying dataset uses row-level security (RLS)."
After deleting the report from the workpsace and re-publishing plus re-adding the user group to read permission, this issue is still standing.
Solved! Go to Solution.
Update:
Wihout doing anything the RLS works again.
Hi @f13 ,
This error suggests that there may be a problem with the way RLS is set up or the way users are recognized within the system, so I think you first need to make sure that the UPN used in the function maps correctly to the user's email address. You can look at this topic: Solved: The report can't be viewed because the underlying ... - Microsoft Fabric Community
Secondly I see that you have raised the following image:
So I think you may want to consider using a card visual object which may give you the effect you are looking for.
Since you have tried to delete and republish the report, make sure that when you re-add the user group, you also reconfigure the permissions exactly as they were when you worked on it previously.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
41 | |
25 | |
24 | |
20 | |
18 |
User | Count |
---|---|
54 | |
42 | |
24 | |
21 | |
20 |