List all connections for all users

[Anonymous]

Hello,

Is there a way for an administrator to get a list of all Connections established in a capacity?

We would like to audit all connections and their user permissions. We've found that admins can only see connections that have been shared with them or they have created. This leaves potential for connections not visible to our audit process.

How can we see all connections, irrespective of sharing?

Thank you.

[v-pgoloju]

Hi @Anonymous,

Just following up to see if the Response provided by community members were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju · Accepted solution]

Hi @Anonymous,

Yes, that’s correct this approach with the API will only show connections that are linked to datasets. It won’t include any unused connections.

Regards,

Prasanna Kumar

[v-pgoloju]

Hi @Anonymous ,

Just following up to see if the Response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[Anonymous]

Hi Prasanna,

I have looked into this. My understanding is this approach will only show used connections, not unused connections - is that right?

We have hundreds of datasets. Is there an easy way to identify ones that are only used for Fabric/Powerbi?

[v-pgoloju]

Hi @Anonymous,

Just following up to see if the response provided was helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @Anonymous,

Right now, there’s no direct Fabric CLI command to see all data connections for every user in Power BI. The only way is to use the Power BI Admin REST APIs: first get a list of all datasets with GetDatasetsAsAdmin, then check each dataset’s connections using GetDatasourcesInGroup. You need Power BI Service Administrator rights for this, and while the CLI could run these API calls, it doesn’t have a built-in command to do it automatically.

Thanks & Regards,

Prasanna Kumar

[v-pgoloju]

Hi @Anonymous,

Just following up to see if the response provided were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[Anonymous]

Hi @v-pgoloju ,

I have not tried yet. Is there a way to do this with Fabric CLI?

Thanks,

David.

[v-pgoloju]

Hi @Anonymous,

Thank you for reaching out to the Microsoft Fabric Forum Community.

To view all data connections created by all users in Power BI using only REST APIs, an administrator must use the Power BI Admin REST APIs. While there is no direct GetDatasourcesAsAdmin API, you can achieve this by first calling GetDatasetsAsAdmin to retrieve all datasets in the tenant. Then, for each dataset, use the GetDatasourcesInGroup API to extract connection details. This process requires Power BI Service Administrator rights and is currently the only REST API-based method to audit all connections across the environment.

Thanks & Regards,

Prasanna Kumar