Skip to main content

Microsoft Dataverse - Automatic Data Lineage

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 response and build it in two directions.

  1. Form reads from table to get its fields.
  2. Form writes to table after filling up form.
Form lineage

Known 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 the 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 an older version or configuration was incorrect.