Microsoft Power BI (Azure) lineage configuration
To import lineage metadata from Microsoft Power BI (Azure), create a connection, data source definition and metadata import job.
To import lineage metadata for Microsoft Power BI (Azure), complete these steps:
- Create a data source definition.
- Create a connection to the data source in a project.
- Create a metadata import.
Creating a data source definition
Create a data source definition. Select Microsoft Power BI (Azure) as the data source type.
Creating a connection to Microsoft Power BI (Azure)
Create a connection to the data source in a project. For connection details, see Microsoft Power BI (Azure) connection.
Creating a metadata import
Create a metadata import. Learn more about options that are specific to Microsoft Power BI (Azure) data source:
Include and exclude lists
You can include or exclude assets up to the the report level. Provide workspaces and reports in the format workspace/report. Each part is evaluated as a regular expression. Assets which are added later in the data source will also be included or excluded if they match the conditions specified in the lists. Example values:
: all reports inmyWorkspace/
,myWorkspace
: all reports inmyWorkspace2/.*
,myWorkspace2
:myWorkspace3/myReport1
frommyReport1
,myWorkspace3
: any report inmyWorkspace4/myReport[1-5]
with a name that starts withmyWorkspace4
and ends with a digit between 1 and 5.myReport
External inputs
You can add Microsoft Power BI (Azure) Reports, Dataflows, and PowerQuery script as external inputs. The file can have the following structure:
<workspace_name> - A folder with the workspace name. [report_name].pbix - A PowerBI report. [dataflow_ID].dataflow - A PowerBI dataflow. [report_name].txt - Manually extracted PowerQuery scripts for a specific report. [report_name].rdl - A paginated report. metadata.json - A file with metadata. If this file is provided, it overrides metadata that is extracted automatically for the specified workspace.
Learn more
Parent topic: Supported connectors for lineage import