Extract gateway connections details - Data source and User having access to each connection

[Anonymous]

Hello Power BI Admins, I have a requirment to produce a list of all the connections configured on the On-Premise or Enterprise Gateway. I did not find anything online so posting question here.

is it possible to extract a list with details:

1. list of data source (Connection name, source type, server/dbname or linketc, Authentication type).

2. list of users having access to each connection.

[strawn]

Hello,

for the record, point 1 (list of data sources) can be done using the API :

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

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

After research, there is no such list including data source and users. You need to produce them one by one.

Best Regards,
Angelia

[Anonymous]

Angelia, Thanks for the quick response

Is there any chance of this beeing made available in future. Is there any Idea that i can vote(link).

[v-huizhn-msft]

Hi @Anonymous,

Please review the following idea and comment on it.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31710763-gateway-management-tool-cli

Thanks,
Angelia

[Anonymous]

Thans Angelia for the link. I voted and also had a coment i the link you provided.

Hope this comes back sooner.

[v-huizhn-msft]

Hi @Anonymous,

It's my pleasure to help you, could you please mark the useful reply as answer, so more people like you can get information easily.

Thanks,
Angelia