Can I use "Publish to Web" reports web with Row-Level Security ?

[yoshihirok]

I want to use both "Publish to Web" and "Row-Level Security".

Now, The "Publish to Web" reports can NOT show any visuals after adding "Row-Level Security".

Repro step:

1. Create a report by Power BI Desktop.

2. Publish the report to Power BI Service by Power BI Desktop.

3. "Publish to Web" the report by Power BI Service.

4. Show the "Publish to Web"'s report url by Web Browser => can show all visuals.

5. Add a "Row-Level Security"'s role to the dataset by Power BI Service.

6. Show the "Publish to Web"'s report url by Web Browser => can NOT show any visuals. 

Can I use "Publish to Web" reports web with Row-Level Security ?

Regards,
Yoshihiro Kawabata

[EHopkins]

It would be nice to generate an embed code that is inclusive of the RLS. That limitation halted an idea we had for embedding dashboards in Sharepoint that were specific to the users who were looking at them.

[ankitpatira]

@yoshihirok Unfortunately no you cannot use RLS and Publish to Web together. They are both contradicting. With RLS you have to define roles and add users to those roles thereby limitng access to specific users. Publish to web makes reports available on world wide web with no way of identifying users (by their email or usernames). Therefore when you enabled RLs on dataset you cannot see any visuals via publish to web.

[yoshihirok]

Hi, @ankitpatira for your information.

I wish there are some specific user/role for "Publish to Web" in Row-Level Security.

Wish like user of "Web", or role of "Web".

Thank you.

Regards,
Yoshihiro Kawabata