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

May 08, 2024

Azure Power BI Scanner OCF Connector: Version 2.2.1

Fixed Issues

Lineage Gaps Between Power BI and Snowflake

Lineage gaps between Power BI and Snowflake due the following issues has now been fixed (AL-148070, AL-147313):

  • Table names containing a period (“.”).

  • Reserved keywords used as parameters. For example, Server and Database.

Lineage Gaps Between Power BI and SQL Server

There are lineage gaps in Power BI connector and SQL Server due to issues related to reserved keywords used as parameters, for example, Database.

The issue is fixed now. (AL-124119)

Out of Memory Errors Due to Incorrect Parsing of Dataset Parameter Expressions

Metadata Extraction resulted in out-of-memory errors due to incorrect replacement of integers in dataset expressions when integers are used as parameters.

This issue is now fixed. (AL-143205)

April 17, 2024

Azure Power BI Scanner OCF Connector: Version 2.2.0

Enhancements

Support for Power BI Column-Level Lineage

Column-level lineage is available for reports created from table-based datasets and dataflows starting in 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.