Forum Discussion
RLS to Published reports
Hello Experts !
may be a silly question, I just wanted to know how can I apply row level security to "published to web" report in powerbi.
my data modeling is ok enough to filter the report content based on the user name. means I have a table where UserName, District_Name is saved and I can match the user name and get the corresponding District_Name which I can use to filter database of the report.
I know very little or almost None about admin stuff of powerbi. I use a "Publish to web" feature and send that link to client (i know publish to web is not safe but client is fine with this) and then they use that URL into their werbsite to show reports. Now client's werbiste has "log-in" feature which my powerbi somehow should use to filter the data (row level security). So could anyone please help me to implement above functionality ??
Hi rbkforPowerBI ,
The answer is no. Without authentication, anyone can access the link to the Publish to web report. This behavior is the opposite of reporting under RLS, i.e., the role needs to be verified before querying the data. This is why Publish to Web is not available for reports with RLS configured.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
3 Replies
rbkforPowerBI Hi, you need to create roles in the Power BI desktop and re-publish/replace the report again.
Here is the detailed documentation for setting up RLS - https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rlsNo, I can't do that. Please check the below thread can't Publish when roles added , and also how come URL come to know which user has "logged in" to filter the dataset ?
Hi rbkforPowerBI ,
The answer is no. Without authentication, anyone can access the link to the Publish to web report. This behavior is the opposite of reporting under RLS, i.e., the role needs to be verified before querying the data. This is why Publish to Web is not available for reports with RLS configured.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
