send powerbi report every friday to users

[lboldrino]

Issue: send powerbi report every friday to users. (but each user may only see his data). 

any idea?

the report has only one table :

email	opps	customer	amount	date
user1@domian.com	opp1	cust1	1000	01.01.2022
user2@domian.com	opp12	cust1	1000	02.01.2022
user2@domian.com	opp1	cust12	1000	03.01.2022
user3@domian.com	opp1	cust13	1000	04.01.2022
user4@domian.com	opp1	cust4	1000	05.01.2022

i did create as manage role userprincipalname as filter on my email column. but it is not correct.

any idea?

thanx! 🙂

[Manoj_Nair]

@lboldrino - check this post recently did. https://community.powerbi.com/t5/Desktop/Row-Level-Security-WITHOUT-user-Email-based-on-userid/m-p/2... 

[lboldrino]

i will send to each users only his data as excel as email. no login to powerbi -> userprincipalname not working.