n8n-nodes-power-bi

This is an n8n community node that allows you to interact with the Power BI REST API to query models, generate insights, and manage Power BI resources.

Features

• Get Workspaces: Retrieve all available Power BI workspaces
• Get Datasets: List datasets within a specific workspace
• Execute DAX Query: Run DAX queries on datasets to generate insights and analytics
• Get Reports: Retrieve reports from a workspace
• Get Dashboards: List dashboards in a workspace
• Refresh Dataset: Trigger dataset refresh operations

Installation

Follow the installation guide in the n8n community nodes documentation.

Credentials

You need to create a Power BI API credential with an access token. To get an access token:

1. Register an application in Azure Active Directory
2. Grant necessary Power BI API permissions
3. Generate an access token using OAuth 2.0 flow
4. Use the access token in your n8n Power BI API credentials

For detailed instructions, see the Power BI REST API documentation.

Operations

Get Workspaces

Retrieves all Power BI workspaces accessible to the authenticated user.

Get Datasets

Lists all datasets in a specified workspace. Requires a workspace ID.

Execute DAX Query

Executes a DAX (Data Analysis Expressions) query on a specified dataset. This is the core feature for AI reasoning and automated insights generation. You can:

• Query data models with complex DAX expressions
• Generate analytical insights
• Retrieve calculated measures and KPIs
• Perform advanced data analysis

Example DAX queries:

EVALUATE TOPN(10, VALUES('Sales'[Product]))
EVALUATE SUMMARIZE('Sales', 'Sales'[Region], "Total", SUM('Sales'[Amount]))

Get Reports

Retrieves all reports in a specified workspace.

Get Dashboards

Lists all dashboards in a specified workspace.

Refresh Dataset

Triggers a refresh operation on a specified dataset to update data from sources.

Usage Examples

Automated Insights Workflow

1. Use "Get Datasets" to find available data models
2. Execute DAX queries to analyze trends and patterns
3. Process results with other n8n nodes for reporting or alerting

Data Pipeline Management

1. Trigger dataset refreshes based on external events
2. Query updated data using DAX
3. Send insights to stakeholders via email or messaging platforms

Requirements

• n8n version 0.174.0 or higher
• Valid Power BI Pro or Premium license
• Azure AD application with Power BI API permissions

License

MIT

Resources

• n8n community nodes documentation
• Power BI REST API documentation
• DAX Reference