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:
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.