Forum Discussion
How to get the user name for the data source
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
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,
2 Replies
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,