Microsoft Dataverse - Automatic Data Lineage

Wojtek Bialek - Dataedo Team Wojtek Bialek 17th July, 2024

What to expect

Views

Dataedo analyzes SQL of Dataverse views with built in SQL Parser and builds column-level lineage from tables/views queried by view to the view.

View lineage

Forms

Dataedo analyzes system forms (from Dataverse environment). We get lineage from API reponse, and build to it in two directions.

  1. Form read from table to get it's fields
  2. Form writes to table, after filling up form

Form lineage

Kown Limitations

  1. Check the limitations for views lineage from SQL parser

Troubleshooting

I don't see data lineage for views

  1. Make sure you have selected right SQL dialect - in this case Transact-SQL (SQL Dialect field at Data Source level).
  2. Rerun import of the source - maybe schema was imported in older version or configuration was incorrect.