Forum Discussion
List all connections for all users
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.
9 Replies
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
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 KumarHi 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
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 KumarHi 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