Forum Discussion
Automatic data source switching based on user login
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 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.