Scanning of Views in SQL Server and Azure SQL
Can you please add the capability to scan for views in SQL Server, Azure SQL and Azure Managed Instance?
Villegas, Christian commented
This is critical for us since we create all of our Power BI feeds to dataflows and datasets using SQL views (that way we can append extra logic before PBI takes over). Without it right it doesn't appear to be generating any lineage whatsoever and the product doesn't appear to be functional within our environment.
Trenton Tamura commented
This is a must. Stored procedure scanning would be nice too... or at least including them for manual input in the lineage. I'm still looking through the forum, that may be addressed already
Mara Cidri commented
It is crucial.
Carlos Rodriguez commented
Right now the tool seems to be able to scan just tables within sql server. For tables it should use the foreign keys setup to identify relations with other tables (not just the schema they belong as it seems to use right now).
For views and procedures it should use output like the provided by sys.sql_dependencies to understand which objects are part of the definition of the view/procedure and mark them as related .
Tim Bush commented
Our #1 feature request is improvements to the lineage view generated from scans.
• Visibility in lineage view of view and stored proc dependencies within a SQL database source
• Visibility of how the Power BI dataset and dataflow assets depend on these SQL objects.
Add Synapse to the list -- scan views on Azure Synapse