Forum Discussion
How to retrieve authenticated user for power BI connector to Exchange Online
Hi crixo,
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:
Row-Level Security (RLS)
Security Groups
Embed Reports (Pro License Required)
If you find this insightful, please provide a Kudo and accept this as a solution.
Super UserHi crixo ,
What ever you are expecting is not possible.But can use power query with parameter and you try similar thing in Excel.
https://exceloffthegrid.com/power-query-using-parameters/
OR You can try pulling all users calendar data using Microsoft graph & add a slicer to filter data based on users details.
https://learn.microsoft.com/en-us/graph/api/user-list-calendars?view=graph-rest-1.0&tabs=http
I hope the information shared by me will be helpful.
Thanks,
Sai Teja
Hi Sasa
I'm using the Parameter as well within the power query/Transform Data/ Advanced Editor but it does not solve my need to have a given user accessing the report via web interface.
The Parameter simplified the user switching in the Power BI desktop app remaining in "Visual Mode" isntead of changing the user identifier into the Advanced Editor/Transfrom mode