How to get the user name for the data source

[Anonymous]

Hi All,

Is there a way to find the user name used for connecting to a data source. One of the main drawbacks of Power BI is we cannot see the user name used to connect to the data source. Please advice.

Thanks

[Anonymous]

Hi @Anonymous ,

You could use USERNAME(0 or USERPRINCIPALNAME() to get the user who are connecting to Power BI Service.

However you can get the user who are connection to data source by Power BI.

Best Regards,

Jay

[ibarrau · Accepted solution]

Hi. You can't. That data is encrypted as a security strength. If you own your model and want to create a table with strings as credentials it's by your own risk, but Microsoft won't allow  you to see the credentials used to get data from a source. You can only check which account is connected in Power Bi Service at the moment ( USERNAME() or USERPRINCIPALNAME() ) that is not the same as the user name of the data source.

Hope that helps,