Forum Discussion
Remove row level security for public access
I have a desktop report which sources data from a local SQL Server view. The data is demonstration data. When I publish the report and embed into my website and a user signs into Power BI, they get a message to say they cannot access because of row level security. Is there anyway I can remove this for public access. I am using the Report for demonstration.
tia
4 Replies
Hi paulfell29 ,
You can disable row-level security (RLS) for your report by removing the roles and rules defined in Power BI Desktop. To do this, open the report in Power BI Desktop, go to the "Modeling" tab, and select "Manage Roles". From there, you can delete any roles that have been defined. Once you have removed all roles, save the report and publish it to Power BI Service. This should allow public access to the report without any RLS restrictions. However, please note that this will remove any data-level security that you may have implemented in the report.
If it does not help, please provide more details.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Does this make the dashboard public for anyone to see or only those that are invited to the dashboard
With the help of MS, I was able to make entirely public. Anyone can see.
