Power BI Get list of connections with list of users with access

[jarwest]

Hey all,

I'm trying to clean up deprecated or duplicated PBI connectors in my gateway, however I'm having a bit of trouble performing discovery. I'd like to get a list of all my connections with the users who have access listed. I so far have found the api to get the connections (https://learn.microsoft.com/en-us/rest/api/fabric/core/connections/list-connections?tabs=HTTP), but it doesn't include user data.

I know I can get the connection users in the website, but I have over 500 connections to go through can can't easily extract a list of users by connection.

I also need to change out some duplicated connections across teams or users for individual, unified connections, and I was wondering if there were any tips for doing so. I don't know if there's a good method for this, if deleting the old connection will roll over reports to the new connection, or if there's any good shortcuts or tips for switching several reports from one connector to another, except for going one at a time and switching them in the dataset settings manually.

Any and all help is appreciated.

[GilbertQ · Accepted solution]

Hi @jarwest 

You could use the power BI REST Apis in order to identify the users of your data source by looping through the data source ID. Here is the API to call. Gateways - Get Datasource Users - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[v-sgandrathi]

Hi @jarwest,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

Thank you.

[v-sgandrathi]

Hi @jarwest,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-sgandrathi · Accepted solution]

Hi @jarwest,

Thank you @GilbertQ for providing answer to the query.

Along with the previously mentioned API, it’s important to note that there isn’t a single Power BI or Fabric REST API that provides both the list of connections and the users with access in one call. To get this information, you usually need to automate the process: first list all connections, then map each one to its gateway or datasource, and finally loop through each datasource to find the associated users and compile the results. This process generally requires tenant-level admin permissions for a complete overview; otherwise, the data may be incomplete.

Additionally, when removing duplicate or outdated connections, deleting an old connection won’t automatically redirect existing reports or models to a new one. Reports or datasets using the deleted connection will fail until manually updated. There is no bulk reassignment option in the Power BI UI, so automation with PowerShell or REST APIs is typically used. Before making changes, it’s best to inventory all dependent datasets, reports, and refresh schedules to prioritize important connections and prevent issues with refreshes or access.

Thank you.

[GilbertQ · Accepted solution]

Hi @jarwest 

You could use the power BI REST Apis in order to identify the users of your data source by looping through the data source ID. Here is the API to call. Gateways - Get Datasource Users - REST API (Power BI Power BI REST APIs) | Microsoft Learn