Power BI authentication using email/user ID

[dronik]

Hello everyone,

My company is moving to Power BI. We are trying to establish data source connections that will allow to call these data sources with authentication using logged in user e-mail or ID.

So for example I want to call database stored procedure or view and read data only for user that is currently accesing dashboard.

What is the best approach to continue? Stored procedures? Web API calls? Does anyone here have experience with similar approaches and preferably any tutorial links?

Thank you in advance!

[v-menakakota]

Hi @dronik   ,
Thanks for reaching out to the Microsoft fabric community forum. 

Use Row-Level Security (RLS) in Power BI. It allows you to restrict data so that each user only sees information relevant to them, based on their login (email or user ID).

By using this DAX expression:

[UserEmail] = USERPRINCIPALNAME()

This ensures the report dynamically shows data only for the logged-in user.

Please go through the below document which may help you in resolving the issue.

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards, 
Community Support Team  

[dronik]

Hello @v-menakakota 

thank you for your answer. Unfortunately your approach wont work in this case, because I need to send logged in user information (whether its his mail or ID) to database first, and the after this call, database needs to return subset of data for retrieved user back to me.

So - I cannot pull all the data from database and then filter it out using DAX based on mail. I need to send mail to database, which then will be processed within database, and database will return only data this user should see.

Regards,

Patryk

[v-menakakota]

Hi @dronik ,

Thank you for the update. Since your requirement involves sending user identity to the database and applying filtering at the source, it may require a specific setup depending on your data source, gateway, and authentication method.

To help you better and review your environment in detail, I’d recommend raising a Microsoft support ticket so our technical team can assist you end-to-end with the configuration.

Please refer below link on how to raise a contact support or support ticket. 
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 
 

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards, 
Community Support Team