Power Query Integration Requirements

Power Query Scanner Overview

The Power Query scanner parses Power Query scripts and creates data lineage.

Supported Features

Note: This is a list of the Power Query features that Manta Data Lineage supports. There may be features that aren't explicitly named yet are included under the items listed, as this list aims to be a high-level overview. Other than that, any features that are not listed are primarily considered not supported.

Datatypes
- Complex (Tables, Records, Lists)
- Primitive (Number, Text, Logical, Null, Date/DateTime/DateTimeZone/Time/Duration)
- Functions
- Types
Expressions
- Let expressions
- Function calls
  - External data sources
    - MS SQL
    - DB2
    - Oracle
    - PostgreSQL
    - Teradata
    - Sybase
    - OLEDB
    - SSAS (only when using an MDX query as a function argument)
- Operations
  - Binary
  - Unary
  - Record lookup
  - List indexer

Known Unsupported Features

IBM Manta Data Lineage does not support the following Power Query features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.

Multiple sections
User-defined functions
If-then-else expressions
SSAS external data source and cube functions