Automate Power BI dataset refreshes with history monitoring

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

This n8n workflow provides automated Power BI dataset refresh capabilities with built-in refresh history monitoring. It triggers a dataset refresh in Power BI and simultaneously checks the refresh history to track data update status. This is perfect for data analysts, business intelligence teams, or anyone who needs to automate Power BI dataset refreshes and monitor their success rates without manual intervention.

Key Features: - Automated Power BI dataset refresh triggering - Simultaneous refresh history monitoring - Manual trigger for on-demand execution - Real-time status tracking - Integration with Power BI REST API - Support for workspace and personal datasets

Step-by-Step Implementation Guide

Prerequisites Before setting up this workflow, you'll need:

1. n8n instance (cloud or self-hosted) 2. Power BI account (Pro or Premium) 3. Microsoft Azure App Registration for API access 4. Power BI dataset that you want to refresh

Step 1: Set Up Azure App Registration

1. Go to [Azure Portal](https://portal.azure.com/) 2. Navigate to Azure Active Directory → App registrations 3. Click New registration 4. Configure your app: - Name: n8n-powerbi-integration - Supported account types: Accounts in this organizational directory only - Redirect URI: https://your-n8n-instance.com/rest/oauth2-credential/callback 5. Click Register 6. Note down the Application (client) ID and Directory (tenant) ID