Publish Power BI on a website : how to filter data for each user ?

[jsteffe]

Hello,

If I publish one power BI on a website, is it possible to automatically filter the data for each user.

For example, th user gives his email on the website and my powerBI report is automatically filtered only on the data related on his email address ? (of course, I get the email as a field in my power BI model).

Thanks,

Jérôme

[amitchandak · Accepted solution]

@jsteffe , RLS is possible but not for the publish on the web. On power bi service data can be filtered based on using RLS

RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns...
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies