Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 adv...
Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    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,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
5 years ago

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,