Credentials Used to Connect

[jdballard30]

Is there a way in the Power BI service to see which credentials are being used for a dataset? I know that I can go to the Datasets tab and see my datasets, and under there I see "Data source credentials" and there is an edit link. What I'm looking for is something to tell me which account is currently used. (Obviously, showing the password is not a good idea. I can also see how revealing the account might be a security issue as well, but I am looking at a dataset and it's using OData to connect, but I can't tell which account!)

[Icey]

Hi @jdballard30 ,

To my knowledge, Power BI doesn't support it due to security reasons.

Or, maybe you can try to use API to get "connectionDetails". It may help you to determine which account is used.

Reference:

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getgatewaydatasources;

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getgatewaydatasourcesingroup.

Best Regards,

Icey

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

[jdballard30]

Thx for the reply.

I figured it was for security. Not showing the password is obvious, but I think a case can be made for at least letting some users see the name of the data source.

As for the APIs, it looks like that is for gateway data sources, and I'm not using a gateway since everything is cloud-based.

[Icey]

Hi @jdballard30 ,

I have tested the API. It also works with datasets not using gateway.

For a sharepoint data source:

Of course, you can try the new API instead:

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasources;

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasourcesingroup.

Best Regards,

Icey

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

[jdballard30]

Thanks for the follow-up! I was able to use the "Try It" button in the documentation and get a succcessful 200 response. Unfortunately, it still doesn't tell me the user account being used to access the data. I understand the security reason of NOT returning the user account, but I can also see an argument to return the account/username being used (but definitely not the password).