In order to understand the impact of removing or changing a Connection or gateway we need to be able to see what uses it and is related to it.
Can we have a view at the connection and gateway level to see which artifacts in which workspaces use them.
Synapse Analytics and Data Factory have linked service 'relate' option, so something similar would be really helpful.
2 Comments
- HaldemanMANew Member
Currently...To get this information, I have to run multiple admin api's, including Get Datasources for each dataset. This takes 10 hours to run through all of our datasets in the tenant. Then I have to map it to the output of Get Datasources for the gateway. I am afraid to just let the 10 hour job run unattended, so I break it up in to workable time segments, which requires this to be a manual process. It is only something that can be done every quarter at best. We can see in the workspace lineage views on the tenant that the data is already linked and available, so please expose the same linkage view from the gateway connection perspective.
Additionally adding "last time used" attribute on the Get Datasource Status api or in the proposed new lineage view, would help us identify inactive connections that are still attached to datasets not being refreshed. I have tried to use the actual gateway logs from the servers, but this only exposes active connections. I have to manipulate the output to throw into Excel and perform vlookups for the connections that don't show up and assume they are inactive from a very limited point of time captured in a log file.
In summary, Administrators don't have time to come up with adhoc solutions such as this and would GREATLY benefit from this view. I know how voting works and this won't even be reviewed most likely. There aren't enough Admins to increase the votes. :(
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Enable "Include My Changes" when sharing reports from Power BI Apps
Business Need: Business users consume reports through Power BI Apps and need the ability to share their current filtered report view with other authorized users. Current Limitation: The "Include ...jakka_pranesh1 hour agoNew MemberNew3Views0likes0CommentsPower BI Subscriptions: Allow Multiple Users to Manage a Subscription
Currently, a Power BI subscription is managed by the individual who created it. For subscriptions used to distribute business reports to groups of users, this creates unnecessary dependency on a sing...annstruchen2 hours agoNew MemberNew9Views1like0CommentsSSH Support for SFTP Connection
We would need to use SFTP with private/public keys. Currently this method is already available on ADF (using Azure Key vault) but not on Fabric Data Factory (only password authentication is supporte...Alfons_Gonzalez2 hours agoNew MemberPlanned4.6KViews110likes23CommentsPower BI Subscriptions: Allow a Generic Power BI Sender Instead of the Subscription Owner
With the recent changes to Power BI subscription emails, subscription notifications can appear to recipients as though they were sent directly by the person who created or owns the subscription. For...annstruchen2 hours agoNew MemberNew6Views2likes0CommentsPower BI Subscriptions: Restore the Ability to Open or Enlarge the Individual Report Page Preview
With the recent changes to Power BI subscription emails, the subscribed report page is displayed as a small preview within the email, and recipients no longer have the ability to open the individual ...annstruchen2 hours agoNew MemberNew6Views2likes0Comments