Forum Discussion

JMLyle's avatar
JMLyle
Icon for Advocate I rankAdvocate I
2 years ago

Extracting the Username being used in a Gateway Data Source

I beleive there is a way to replace the credential being used by a Data Source on a gateway, but I haven't dug into doing that yet.. At the moment, I would just like to be able to ask a Data Sourc...
Need Help
Tips and Tricks
Wikkleyn_81's avatar
Wikkleyn_81
Icon for Super User rankSuper User
2 years ago

JMLyle There is no way to get the credentials used to create the gateway connection. There is an idea raised for this and all votes help.

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=465aea7f-b208-494b-8155-26faeaa21af7

Here is teh technote on teh encryption.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#store-encrypted-credentials-in-the-cloud

You can use the Power BI Rest API to update the credentials using PowerShell:

Gateways - Update Datasource

https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/update-datasource