Azure Power BI Scanner OCF Connector Release Notes

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

April 17, 2024

Azure Power BI Scanner OCF Connector: Version 2.2.0

Enhancements

Support for PowerBI Column Level Lineage

Column level lineage is now available for reports created from table-based datasets and dataflows from Alation version 2024.1.2.

Fixed Issues

Lineage Not Visible for Datasets Created from Dataflows in Different Workspace

Lineage fails for datasets created from a dataflow in present different a workspace. (AL-149160, AL-141424)

December 06, 2023

Azure Power BI Scanner OCF Connector: Version 2.1.3

Compatible Alation Version - 2023.3.2 or higher

Enhancements

Support for Plus Character (+) in Ingested SQL Queries

Azure Power BI Scanner OCF Connector supports a plus sign (+) in the ingested SQL queries for dataset expressions. This enables the extraction of connection information from dataset expressions with queries having ‘+’ (plus character) to generate lineage.

Fixed Issues

Metadata Extraction Fails for Parameters with Same Name As Table Name in Datasets

In Azure Power BI Scanner OCF Connector, MDE fails if a dataset expression has a parameter with the same name as the table name and value as an expression. This is because the length of the object identifier exceeds the limit set by Alation.

November 22, 2023

Azure Power BI Scanner OCF Connector: Version 2.1.0

Compatible Alation version: 2023.3.2 or higher

Enhancements

Support for Cross-System Lineage Between PowerBI and Databricks Unity Catalog, Azure SQL, and Azure Synapse

Alation now supports cross-system lineage between PowerBI and the following data sources:

  • Databricks Unity Catalog

  • Azure SQL

  • Azure Synapse

To start using this feature, perform the following:

  1. Upgrade to Alation version 2023.3.2 or later.

  2. Set the following flag to True using alation_conf:

    alation_conf alation.resolution.DEV_bi_connector_returns_db_for_two_part_schema -s True

  3. Install the latest Azure Power BI Scanner OCF Connector.

For details, see Azure Power BI Scanner OCF Connector.