Microsoft Fabric currently provides the “List Item Connections” REST API, which returns the connections used by a specified Fabric item. However, there is no REST API or UI capability to identify the list of Fabric items that are using a specific connection. This missing reverse lookup makes it difficult to perform impact analysis, governance, and dependency tracking for shared connections.
Users cannot easily determine which items will be affected when modifying or deleting a connection. As a result, managing connections in large workspaces requires manual and error-prone processes. Introducing a workspace-scoped API or UI view to list items associated with a connection would greatly improve discoverability, governance, and operational efficiency.
2 Comments
- It will helpful enterprise governance needs.
dan7Advocate I
The admin of connections needs lots of love. There are many other ideas related to enhancing the ability for Admins to manage and monitor connections. And this list is only in the first 150 of 2,400+ results when searching the ideas site!
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Connection-Permissions/idi-p/4850050 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Take-Ownership-on-Connections-by-Fabric-Administrator/idi-p/4871306 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Ability-for-Admins-to-be-able-to-delete-Cloud-Connections/idi-p/4856245 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Enable-Reverse-Lookup-of-Fabric-Items-Using-a-Connection/idi-p/4922559 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Connections-Lineage/idi-p/4741925 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Add-Description-To-Data-Source-Connection/idi-p/4919494 https://community.fabric.microsoft.com/t5/Fabric-Ideas/See-where-data-source-connections-are-being-used/idi-p/4919370 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Manage-Connection-Names/idi-p/4509764 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Need-to-gain-access-to-the-cloud-connection-as-a-Fabric-Admin/idi-p/4797237 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Editable-connection-path/idi-p/4607363 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Connection-and-Gateway-Usage-View/idi-p/4520347?search-action-id=563549902141&search-result-uid=4520347 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Item-lineage-for-connections-in-Power-BI-service/idi-p/4816943 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Enhanced-Connection-Sharing-and-Bulk-Access-Management-Microsoft/idi-p/4860376 https://community.fabric.microsoft.com/t5/Fabric-Ideas/REST-API-to-Update-Gateway-Cloud-Connection-for-Power-BI/idi-p/4738079 https://community.fabric.microsoft.com/t5/Fabric-Ideas/Fabric-Rest-API-List-Connections-needs-more-query-options/idi-p/4509751
While we're on the topic of connections. Change the UI when connecting to a new source so that first option is to select an existing connection instead of having to enter the connection details and THEN seeing a list of matching connections.
