Solved: How to get the user name for the data source

Anonymous · ‎02-18-2021

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

ibarrau · ‎02-18-2021

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,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

Anonymous · ‎02-26-2021

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 · ‎02-18-2021

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,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog