Catalog Source Configuration > Microsoft Power BI > Introduction to Microsoft Power BI catalog sources

Introduction to Microsoft Power BI catalog sources

You can use Metadata Command Center to extract metadata from a source system.

A source system is any system that contains data or metadata. For example, Microsoft Power BI is a source system from which you can extract metadata through a Microsoft Power BI catalog source with Metadata Command Center. A catalog source is an object that represents and contains metadata from the source system.

Before you extract metadata from a source system, you first create and register a catalog source that represents the source system. Then you configure capabilities for the catalog source. A capability is a task that Metadata Command Center can perform, such as metadata extraction, data profiling, data classification, or glossary association.

When Metadata Command Center extracts metadata, Data Governance and Catalog displays the extracted metadata and its attributes as technical assets. You can then perform tasks such as analyzing the assets, viewing lineage, and creating links between those assets and their business context.

The following table describes the capabilities of the catalog source:

Capability	Description
Data Classification	Data classification is the process of identifying and organizing data into relevant categories based on the functional meaning of the data. Classifying data can help your organization manage risks, compliance, and data security.
Glossary Association	You can associate terms that are in the glossary with technical assets to provide user-friendly business names to technical assets. Glossary Association automatically associates glossary terms with technical assets or recommends glossary terms that you can manually associate with technical assets in Data Governance and Catalog.

Extraction and view process

To extract metadata from a source system, configure the catalog source and run the extraction job in Metadata Command Center. Then view the results in Data Governance and Catalog.

The following image shows the process to extract metadata from a source system:

The image shows the process of metadata extraction from a Microsoft Power BI source system that begins with prerequisites verification, continues with the creation of the catalog source, and ends with viewing the results and lineage.

After you verify prerequisites, perform the following tasks to extract metadata from Microsoft Power BI:

1Register a catalog source. Create a catalog source object, select Microsoft Power BI, and then select and test the connection.
2Configure the catalog source. Specify the runtime environment and configure parameters for metadata extraction. Optionally, add filters to include or exclude source system assets from metadata extraction. You can also configure other capabilities such as data profiling and quality, data classification, or glossary association.
3Optionally, associate stakeholders. Associate users with technical assets, giving the users permission to perform actions determined by their roles.
4Run or schedule the catalog source job.
5Optionally, if the catalog source job generates referenced asset objects, you can assign a connection to referenced source system assets.

You can view the lineage with object references without performing connection assignment. After connection assignment, you can view the objects.

Run the catalog source again after you assign connections to referenced source system assets.

After you run the catalog source job, you view the results in Data Governance and Catalog.

About the Microsoft Power BI catalog source

You can use the Microsoft Power BI catalog source to extract metadata from a Microsoft Power BI source system hosted on the cloud.

Microsoft Power BI is a business intelligence tool that connects data and creates reports and dashboards.

Extracted metadata

You can use the Microsoft Power BI catalog source to extract metadata from a Microsoft Power BI source system.

Metadata Command Center extracts the following metadata from a Microsoft Power BI source system:

•Report

Note: You can also extract metadata from reports generated by Power Query custom functions and DAX functions.

•Workspace
•Dashboard
•Datamart
•Data Set (Semantic Model)
•Tile
•Field
•PaginatedReportDataset
•Dataflow
•Dataflow Table
•Dataset Table

Note: For catalog sources created prior to the November 2024 release, you must run the catalog sources again. When you run the catalog sources again, Metadata Command Center creates a pre-processing job. The pre-processing job updates the extracted metadata to include dataset tables.

Data Analysis Expressions (DAX)

You can use Data Analysis Expressions (DAX) to generate reports.

You can use the following DAX functions:

•ADDCOLUMNS
•ALL
•ALLCROSSFILTERED
•ALLEXCEPT
•ALLNOBLANKROW
•ALLSELECTED
•AVERAGE
•AVERAGEX
•CALCULATE
•CALCULATETABLE
•CALENDAR
•CALENDARAUTO
•COMBINEVALUES
•CONCATENATE
•CONCATENATEX
•CONTAINS
•CONTAINSROW
•CONVERT
•COUNT
•COUNTA
•COUNTAX
•COUNTROWS
•COUNTX
•CROSSJOIN
•DATATABLE
•DATE
•DATEADD
•DISTINCT
•EXCEPT
•FILTER
•GENERATESERIES
•GROUPBY
•HASONEFILTER
•HASONEVALUE
•IF
•ISCROSSFILTERED
•ISEMPTY
•SFILTERED
•KEEPFILTERS
•MAX
•MAXX
•MEDIAN
•MEDIANX
•MIN
•MINX
•PERCENTILEX_EXC("PERCENTILEX.EXC")
•PERCENTILEX_INC("PERCENTILEX.INC")
•PERCENTILE_EXC("PERCENTILE.EXC")
•PERCENTILE_INC("PERCENTILE.INC")
•PRODUCT
•PRODUCTX,
•RANKX
•RELATEDTABLE
•REMOVEFILTERS
•ROW
•SELECTCOLUMNS
•STDEVX_P("STDEVX.P")
•STDEV_P("STDEV.P")
•SUM
•SUMMARIZE
•SUMMARIZECOLUMNS
•SUMX
•SWITCH
•TABLE_CONSTRUCTOR
•TABLE_REFERENCE
•TOPN
•TREATAS
•UNION
•USERELATIONSHIP
•VALUES
•GENERATE
•GENERATEALL
•NATURALLEFTOUTERJOIN
•NATURALINNERJOIN

Compatible connectors

Before you configure a Microsoft Power BI catalog source, you must connect to the Microsoft Power BI source system.

Use the Microsoft Power BI connector to connect to the Microsoft Power BI source system.

For information about configuring a connection, see Connections.