Power BI Collibra Integration – Easy Connections

Easy Connections is an Expleo’s integration platform which runs on Customer’s environment to integrate various source systems to Collibra.

PowerBI Connector runs on top of this Easy Connections platform to integrate metadata, lineage to datasets, and user permissions to reports and folder/workspaces into Collibra Platform.

Use Case(s)

• Traceability/Lineage – provide the ability to trace the provenance of a report attribute to its source
• Report Certification
• Ability to do an impact analysis of changes in the data sources on the downstream Power BI reports that consume data from these sources

Expleo’s Collibra-Power BI Integration ingests the following Power BI metadata into Collibra: 

• Workspace, App, Report, Report Page, Visual container, report attributes, Dataset, Power BI Tables, Power BI Columns, Power BI Measures, Power BI Hierarchy, Power BI Level, Power BI Static Table, Static Column, Filter, Power BI Datasource, Dashboards and Tiles 
• The report attributes of the visual containers in report pages are loaded along with their relations with Power BI column and measures 
• Relational data sources and Excel data sources are supported. i.e. their metadata are loaded into Collibra DIC to provide an end-to-end lineage from the report attribute to its source field/column in the data sources. This metadata is captured from Power BI. The actual metadata of these physical data sources must be separately loaded using EDGE or Expleo’s database integrations 
• Detailed attribute-level metadata extracted from Power BI Dashboards and Reports and lineage enabled to the physical data assets 
• Data Sources supported: SSAS Tabular View, relational databases, Flat files / Excel, other ODBC sources, OData feeds 
• For Power BI Service, the asset extraction can be filtered based on Workspace, Dashboard and Report 
• For Power BI Report server, the asset extraction can be filtered based on Folder and Report 
• Support for Power BI Apps – captured as a group of assets such as the reports, dashboards and data sets packaged as part of the App  
• Support for custom attributes captured as part of Power BI reports as enhanced metadata 
• Support for handling renames of Workspaces, Dashboards, Tiles, and Folders assets without their deprecation 
• Support for Shared datasets on Power BI Service 
• SQL Parsing supported using 3rd party tools as a custom extension 
• Support for dataset, dataflows and report-filter metadata, creation of Tags using custom attribute mapping 
• Support for Sensitivity labels (for reports) and Endorsement attribute (for reports) 
• Multiple authentication options for both Power BI service and Report server 
• Support for credentials management in Azure Key Vault, AWS Secret Manager, Cyberark 

For a detailed feature set, refer to the attached datasheet. 

The Standard edition of the integration is offered on an annual subscription. A free trial subscription is also available.