Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 admi...
Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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