Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am working on Embedding a power BI dashboard on a client website, but the data source must automatically be changed depending on the logged in user. How can I acheive this?
Hi @Anonymous
Thank you for sharing that solution. But how can we dynamically retrieve the user's email address in Power query ?, since there is no native function to do that. I know that in case of DAX function we can use UPN to get the email address of the logged in user.
But, for Power query is there any workaround. I have looked everywhere but have not found anything related to it.
Hi @srbh24 ,
For your question, I think you can create a table that stores the user's email address and the data source connections that can be accessed. Dynamically get the email address of the user who logged in to the service in Power Query. Use ‘Table.SelectRows’ in Power Query to filter the tables that store the user's email address and the data source connections. Create a parameter, stores filtered connection information. Use this parameter to create a connection to the data source.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |