How to retrieve authenticated user for power BI connector to Exchange Online

Unfortunately, directly retrieving the authenticated user within the Power BI connector for Exchange Online (published to the Power BI service) isn't possible. This is due to security limitations to prevent unauthorized access to potentially sensitive data.

Here are some of the authentication differences between Power BI Desktop and the Power BI service:

Power BI Desktop:

• Users authenticate with their credentials within the desktop application.
• The connector leverages those credentials to access data.

Power BI Service:

• Reports are published and shared with users.
• Users accessing the report inherit the data access permissions granted to the report itself.
• The report itself doesn't have the capability to retrieve or utilize the individual user's credentials.

You can go for alternate solutions as:

1. Row-Level Security (RLS)

2. Security Groups

3. Embed Reports (Pro License Required)

If you find this insightful, please provide a Kudo and accept this as a solution.