how to display reports only for logged in user in PowerBi.com ?

[Pradeep]

Hi, I am developing an employee report in powerbi.com. All the data is in Azure SQL DB and we have billions of rows of data. I designed report in Power BI Desktop with direct query. I exported my report into Pbix file to power bi.com Now for Example, Employee1 logs into PowerBI.com and login using an email ID Employee1@microsoft.com. Now when this Employee1 sees report, we would like to get data from Azure SQL only for that Employee1 and show the report in powerbi.com. What i meant is that, we only show the report that contains logged in user data only. how do we pass powerbi.com logged in user information to query in real time. Thank You -Pradeep

[v-qiuyu-msft · Accepted solution]

---

@Pradeep wrote:
Hi, I am developing an employee report in powerbi.com. All the data is in Azure SQL DB and we have billions of rows of data. I designed report in Power BI Desktop with direct query. I exported my report into Pbix file to power bi.com Now for Example, Employee1 logs into PowerBI.com and login using an email ID Employee1@microsoft.com. Now when this Employee1 sees report, we would like to get data from Azure SQL only for that Employee1 and show the report in powerbi.com. What i meant is that, we only show the report that contains logged in user data only. how do we pass powerbi.com logged in user information to query in real time. Thank You -Pradeep

---

Hi @Pradeep,

If I understand correctly, you want to set the user can only view his/her own data when he/she access the report from Power BI Service, right?

In this scenario, what you need is Row-Level-Security. As you have add the filter like "[Emp_Name] = USERNAME()" in Power BI Desktop, you need to apply this role for the dataset of the report. Assume in the Azure database has one column (eg: UserName ) contains user's User Principal Name (UPN) which is similar to email address, you can set the filter like below:

Then in Power BI Service,  you can add a member to the role, then Test as Role.

Reference:

Manage security on your model

Best Regards,
Qiuyun Yu