--- sourceDocument: Australia Workflow Data Fabric sourceDocumentLink: https://www.servicenow.com/docs/r/australia/integrate-applications Release : - australia ft:locale : - en-US ft:publication_title : - Australia Workflow Data Fabric ft:clusterId : - crint bundleId : - crint workflow : - Creator --- # Create a PowerBI metadata collector # Create a PowerBI metadata collector {#ariaid-title1} Release version: Australia Updated March 12, 2026 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 5 minutes to read Create a collector to import metadata from PowerBI. ## Before you begin Before you begin, verify the following: * All per-requisite tasks are completed. For more information, see [Prepare to run the PowerBI collector](https://www.servicenow.com/docs/4sKE64b0YoCzv1fJWvPxPQ "Set up Azure application registration, authentication, and permissions before running the collector."). * If you plan to run the collector on-premise, a MID Server is setup for the collector. For more information, see [MID Server for metadata collectors](https://www.servicenow.com/docs/QcdynKbGhxv_ZIEalalxAg "When your source is behind a firewall or requires on-premises handling, deploy metadata collectors on a MID Server you host to harvest metadata from on-premises and privately networked data sources."). * Role required: connection-admin {#create-powerbi-metadata-collector__ul_pvj_mz5_bjc} ## Procedure 1. Navigate to AllWorkflow Data FabricWorkflow Data Fabric Home. 2. Select the Connect Hub ![Connect Hub icon]() icon in the left sidebar. 3. Select CreateMetadata collector. 4. From the System list, select PowerBI. 5. From the Connection type list, select one of the following: 1. Select New connection to configure a new connection. 2. Select Existing connection to reuse an existing connection and select an existing connection from the Connections list. The configuration form is filled with details from the existing connection. The name is appended with the word Copy and sensitive details like password aren't copied. {#create-powerbi-metadata-collector__substeps_lgh_q4y_jjc} 6. Complete the form. {#create-powerbi-metadata-collector__table_axw_2j2_h3c__entry__2} | Field | Description | |-|-| | Connection name | Unique identifier for the connection. This field can't be modified once the connection is established. | | Short description | Purpose and details of the connection. | [Table 1. PowerBI metadata collector form] {#create-powerbi-metadata-collector__table_axw_2j2_h3c} 7. Configure the connection options. {#create-powerbi-metadata-collector__table_s3_collector_props__entry__2} | Field | Description | |-|-| | Use MID server | Option to connect to the source system through a MID Server. When selected, the MID selection options appear. | | MID selection | MID Server routing option for the collector job. This field appears only when Use MID server is selected. * Auto-Select MID Server --- The system selects an available MID Server at job execution time. Default selection. * Specific MID Server --- The collector job runs on the selected MID Server. If the MID Server is offline at job execution time, the job fails with an error identifying the MID Server by name. * Specific MID Cluster --- The collector job runs on any available MID Server within the selected cluster. | | MID Server | MID Server to use for the collector job. This field appears only when Specific MID Server is selected. The selected MID Server is saved on the collector record and used for all subsequent collection runs until changed. | | MID Cluster | MID cluster to use for the collector job. This field appears only when Specific MID Cluster is selected. The selected cluster is saved on the collector record; any available MID Server within the cluster may serve the job. | | Capabilities | One or more capability labels that restrict auto-selection to MID Servers advertising those capabilities. This field appears only when Auto-Select MID Server is selected. | | MID application | MID Server application to use for the collector job. This field appears only when Auto-Select MID Server is selected. | [Table 2. Connection options] {#create-powerbi-metadata-collector__table_s3_collector_props} 8. Configure the authentication options. {#create-powerbi-metadata-collector__table_h4k_3g2_h3c__entry__2} | Field | Description | |-|-| | Authenticate using Azure username and password | Azure Active Directory username and password. Set the Azure Tenant ID if you want to specify the Azure tenant ID while using the user name and password authentication. | | Authenticate using Azure Service principal | Azure Active Directory application tenant ID for Power BI app. To find the tenant ID, select the question mark in the Power BI app and then choose About Power BI. The tenant ID is found at the end of the Tenant URL. | [Table 3. Authentication options] {#create-powerbi-metadata-collector__table_h4k_3g2_h3c} 9. Configure the client ID and client secret details. {#create-powerbi-metadata-collector__table_sdh_552_m3c__entry__2} | Field | Description | |-|-| | Microsoft Entra client ID | Application client ID for the PowerBI app. | | Microsoft Entra client secret | Application client secret for the PowerBI app. | [Table 4. Configuration details] {#create-powerbi-metadata-collector__table_sdh_552_m3c} 10. Configure the workspace scope and filters options. {#create-powerbi-metadata-collector__table_qpw_5xc_j3c__entry__2} | Field | Description | |-|-| | Disable Lineage collection | Option to skip harvesting lineage metadata from Power BI source expressions. | | Catalog contents of user's My Workspace | Option to catalog the contents of a user's My Workspace in Power BI. Default: Skip the user's workspace. | | Catalog all workspaces and apps in tenant | Option to catalog all workspaces and apps in a tenant, rather than only the workspaces and apps the credentials have explicit access to. Admin privileges are required for the credentials used. | | Include Power BI workspace(s) | Workspaces to collect. Enter the exact workspace name or a regular expression to match. Note: If a workspace name includes special characters \[. , + , \* , ? , \^ , $ , ( , ) , \[ , \] , { , } , \| , \\\], escape each special character with a backslash (\\). For example, enter Workspace \\(Dev\\) for Workspace (Dev). | | Exclude Power BI Workspaces | Power BI workspaces and their contents to exclude from cataloging. Enter the exact workspace name or a regular expression to match. If both Include Workspaces and Exclude Workspaces are configured, Include Workspaces takes precedence. Note: If a workspace name includes special characters \[. , + , \* , ? , \^ , $ , ( , ) , \[ , \] , { , } , \| , \\\], escape each special character with a backslash (\\). For example, enter Workspace \\(Dev\\) for Workspace (Dev). | [Table 5. Workspace scope and filters options] {#create-powerbi-metadata-collector__table_qpw_5xc_j3c} 11. Configure the connection and reliability options. {#create-powerbi-metadata-collector__table_yhb_plp_33c__entry__2} | Field | Description | |-|-| | Maximum Power BI Expression Length | Maximum number of characters in a Power BI expression that is parsed for lineage metadata. Expressions longer than this value are skipped. Default: 32000 | | Datasource Name Mapping File | File that maps ODBC source details configured in the [datasources.yml](https://www.servicenow.com/docs/gCleRECiklKs0lnY_gXuZA "Create a YAML file to map data sources for lineage harvesting.")file. Upload the file if you have configured ODBC source details. | | Catalog report preview images | Option to catalog preview images. Default: false | | Disable max requests wait | Option to disable waiting for the Power BI API to reset throttling limits (error code 429). When not selected, the collector retries every 5 minutes for up to an hour. When selected, the Max retries and Retry delay settings are used instead. | | Max retries | Number of times the system retries a failed API call. Default: 5 | | Retry delay | Number of seconds to wait between retry attempts for a failed API call. Default: 2 seconds | [Table 6. Connection and reliability options] {#create-powerbi-metadata-collector__table_yhb_plp_33c} 12. Select Save. ## Result The metadata collector is created and appears on the Connectors page with a Configured status. It is now ready to connect to the source system and harvest metadata. ## What to do next After creating the collector, you can perform any of the following tasks: * Run the collector manually to harvest metadata immediately. See [Run metadata collectors manually](https://www.servicenow.com/docs/rSO2~8_TxqskZXvlz0R2iw "Execute a metadata collector on-demand to import metadata immediately."). * Automate metadata collection by scheduling regular collector runs. See [Schedule metadata collector runs](https://www.servicenow.com/docs/efDmDhMov5_Wj~hCB2Qv5Q "Schedule a metadata collector to run automatically at a specified frequency."). * Monitor execution status and troubleshoot issues by viewing the runtime logs. See [View runtime logs for collector runs](https://www.servicenow.com/docs/usaS0NCo4Gro712LVBIf3w "Access execution logs and download detailed log files for metadata collector runs."). * Discover and evaluate the harvested data assets in the Data Catalog. See [Governing the Data Catalog](https://www.servicenow.com/docs/~W6YqTji8ALzdDHDEBkFBQ "Data stewards add business context to catalog assets, making them more discoverable for catalog consumers. Governance tools include glossary terms, tags, domains, and direct asset updates."). *[\>]: and then