n8n-nodes-powerbi

This package contains nodes for n8n that enable complete integration with Microsoft Power BI REST APIs. These nodes enable automation, integration, and orchestration of data flows with Power BI directly in n8n.

About the Author

This Community Node was created and made freely available by Anderson Rocha from Universo Automático for the community and was designed to simplify and abstract all the complexity of using Power BI APIs.

Social Media

• Linkedin: https://www.linkedin.com/in/andersonsantosrocha
• YouTube: https://www.youtube.com/@universoautomatico
• Instagram: https://www.instagram.com/universoautomatico/
• N8N + Power BI Training: https://n8npowerbi.com/

Table of Contents

• Features
• Available Resources
• Authentication Methods
• Setting up the Application in Microsoft Entra ID (Azure AD)
• Using the Nodes
• Limitations and Troubleshooting
• Additional Resources

Features

This package offers two main nodes:

1. Power BI

Main node that uses OAuth2 authentication with Microsoft Entra ID (formerly Azure AD) and offers complete functionality for:

• Managing reports, dashboards, and datasets
• Workspace (groups) administration
• DAX query execution
• Data refresh
• Report export
• Gateway management
• Dataflow operations

2. Power BI (Header Auth)

Alternative node that allows authentication via Bearer token passed directly as a parameter. Useful for:

• Integration with other flows that already have authentication tokens
• Implementation of custom authentication flows
• Quick testing and prototyping

Both nodes can be used as AI tools in the n8n AI Assistant, enabling natural language-based automations.

Available Resources

Administration Resources

• Get Workspace Information: Retrieves complete details about workspaces, including dataset schema, DAX expressions, lineage, and data sources
• Get Scan Results: Retrieves workspace scan results

Dashboard Resources

• List Dashboards: Retrieves all dashboards in a workspace
• Get Dashboard: Retrieves details of a specific dashboard
• Get Tiles: Retrieves tiles from a dashboard

Dataset Resources

• List Datasets: Retrieves all datasets in a workspace
• Get Dataset: Retrieves details of a specific dataset
• Refresh Dataset: Initiates a dataset refresh operation
• Get Tables: Lists all tables in a dataset
• Add Rows: Adds data to a dataset table
• Execute DAX Queries: Performs DAX language queries on a dataset
• Get Refresh History: Retrieves dataset refresh history

Dataflow Resources

• List Dataflows: Retrieves all dataflows in a workspace
• Get Dataflow: Exports the specified dataflow definition to JSON
• Get Dataflow Data Sources: Returns a list of data sources for the specified dataflow
• Get Dataflow Transactions: Returns a list of transactions for the specified dataflow
• Refresh Dataflow: Triggers a refresh for the specified dataflow

Gateway Resources

• List Gateways: Returns a list of gateways for which the user is an administrator
• Get Gateway: Returns the specified gateway details
• Get Datasource: Returns the specified datasource from the specified gateway
• Get Datasources: Returns a list of datasources from the specified gateway
• Get Datasource Status: Checks the connectivity status of the specified datasource
• Get Datasource Users: Returns a list of users who have access to the specified datasource

Group (Workspace) Resources

• List Groups: Retrieves all accessible workspaces
• Get Group: Retrieves details of a specific workspace
• Get Reports: Lists reports in a workspace
• Get Dashboards: Lists dashboards in a workspace
• Get Datasets: Lists datasets in a workspace

Report Resources

• List Reports: Retrieves all reports in a workspace
• Get Report: Retrieves details of a specific report
• Get Pages: Lists pages in a report
• Export File: Exports a report in various formats

Authentication Methods

This node supports OAuth2 authentication:

1. OAuth2: For applications acting on behalf of a user through interactive flow.

Token Renewal

It's important to note that Power BI credentials typically expire around 1 hour to 1 hour and 30 minutes. n8n refreshes service tokens only when a 401 error occurs when the token expires, but Power BI by default returns a 403 error. The credential will be maintained once n8n includes this 403 error status in its authentication handling.

AI Tools Integration

The Power BI and Power BI (Header Auth) nodes have been configured as AI tools within n8n, allowing them to:

1. Be easily accessed by n8n's AI assistant
2. Be used in natural language-driven automations
3. Appear in the AI tools palette in the flow editor

Setting up the Application in Microsoft Entra ID (Azure AD)

To use the Power BI node with OAuth2 authentication, you need to register an application in Microsoft Entra ID (formerly Azure AD). Follow the steps below:

1. Register a New Application

1. Access the Azure Portal.
2. Navigate to Microsoft Entra ID > App registrations.
3. Click New registration.
4. Provide a name for the application, for example "n8n Power BI Integration".
5. In Supported account types, select Accounts in this organizational directory only.
6. In the Redirect URI section, select Web and enter: https://your-n8n-domain/rest/oauth2-credential/callback.
   • For local development environment, use: http://localhost:5678/rest/oauth2-credential/callback
7. Click Register.

2. Configure API Permissions

1. In the registered application's side menu, click API permissions.

2. Click Add a permission.

3. Select Power BI Service.

4. You can choose between Delegated permissions (for OAuth2 and ROPC) or Application permissions (for Service Principal):

   For delegated permissions (recommended for most cases):

   • Dataset.Read.All
   • Dataset.ReadWrite.All
   • Report.Read.All
   • Report.ReadWrite.All
   • Dashboard.Read.All
   • Dashboard.ReadWrite.All
   • Workspace.Read.All
   • Workspace.ReadWrite.All
   • Content.Create
   • Tenant.Read.All (for administrative functions)

   For application permissions (Service Principal):

   • Dashboard.Read.All
   • Report.Read.All
   • Dataset.Read.All
   • Workspace.Read.All
   • Tenant.Read.All

5. Click Add permissions.

6. If using Service Principal, you'll need to request an administrator to Grant admin consent for [your directory].

3. Create the Client Secret

1. In the side menu, click Certificates & secrets.
2. In the Client secrets section, click New client secret.
3. Add a description and select an expiration period.
4. Click Add.
5. IMPORTANT: Immediately copy the generated secret value, as it cannot be viewed again.

4. Get Configuration Values

Note the following values that will be needed to configure the node in n8n:

• Client ID: Found in Overview > Application (client) ID
• Client Secret: The value you copied when creating the client secret
• Tenant ID: Found in Overview > Directory (tenant) ID

Using the Nodes

Power BI (OAuth2)

1. Add the Power BI node to your workflow.
2. Configure the OAuth2 credential:
   • Client ID: The registered application ID
   • Client Secret: The generated client secret
   • Scope: Leave blank or use https://analysis.windows.net/powerbi/api/.default
   • Auth URI: https://login.microsoftonline.com/common/oauth2/v2.0/authorize
   • Token URI: https://login.microsoftonline.com/common/oauth2/v2.0/token
   • Auth URL Query Parameters:

     {
       "resource": "https://analysis.windows.net/powerbi/api"
     }

3. Select the desired resource (dashboard, report, dataset, group, gateway, dataflow) and operation.
4. Configure the operation-specific parameters.

Power BI (Header Auth)

1. Add the Power BI Header Auth node to your workflow.
2. Provide a Bearer authentication token in the format:
   • Without "Bearer" prefix: eyJ0eXAiOiJKV...
   • Or with prefix: Bearer eyJ0eXAiOiJKV...
3. Select the desired resource and operation.
4. Configure the operation-specific parameters.

Limitations and Troubleshooting

Power BI API Limitations

• Rate limits: The Power BI API imposes rate limits that may vary depending on your license and subscription plan. Learn more
• Permissions: Many operations require administrative or owner permissions in the workspace
• Some operations require Premium license: Certain operations like programmatic refresh or DAX queries in large volumes may require Premium capacity

Common Issues

1. 403 Forbidden Error:

   • Verify that the user or application has adequate permissions in Power BI
   • Confirm that the necessary API permissions have been granted in Microsoft Entra ID
   • Check if administrative consent has been provided for the permissions

2. 401 Unauthorized Error:

   • The token may have expired - verify that your credentials are valid
   • Check if the Client Secret is still valid (they expire as configured)

3. Dataset refresh errors:

   • Ensure that the dataset allows API refreshes
   • Verify that data source credentials are updated in the dataset

Additional Resources

• Official Power BI REST API Documentation
• Power BI Developer Center
• Power BI API FAQ
• Power BI Known Limitations
• n8n Custom Nodes Documentation

License

MIT