Power BI is business intelligence software that can integrate with various data sources. When you ingest Power BI metadata, Collibra Data Lineage tries to automatically stitch this metadata to data sources registered in Data Catalog. It also creates a technical lineage that shows where metadata is used and how it transforms.
The following table shows the supported data source types in Power BI that have been tested.
Warning Although the following data sources have been tested extensively, there still may be some issues caused by unsupported elements within the data source or limitations in the Power BI integration process.
|
Power BI data source |
Connection type |
Technical lineage |
Stitching to registered data sources in Data Catalog |
|---|---|---|---|
|
Amazon Redshift |
Import |
Yes |
Yes |
|
Azure Databricks |
Import |
Yes |
Yes |
|
Google BigQuery |
Import |
Yes |
Yes |
| Netezza | ODBC Netezza driver |
Yes |
Yes |
| ODBC | Import |
Yes |
Yes Important You need to use a Power BI <source ID> configuration file to provide the true system names of the ODBC databases in Power BI. For more information, see Providing ODBC database names in Power BI. |
|
Oracle |
Import |
Yes |
Yes |
|
Snowflake |
Import |
Yes |
Yes |
|
SQL Server |
Import |
Yes |
Yes |
|
Sybase |
Import |
Yes |
Yes |
Note We cannot guarantee that other data sources in Power BI can be stitched successfully.