This n8n workflow streamlines the process of manually triggering a Power BI dataset refresh and monitoring its refresh history. Ideal for users who frequently need to update Power BI reports and want an easy way to check the latest refresh status, this automation provides a seamless solution to keep data current without manual API calls or logins.

Starting with a manual trigger, the workflow initiates a refresh of a specified Power BI dataset using the Power BI API. After the refresh command is sent, the workflow automatically proceeds to retrieve the recent refresh history, allowing users to verify if the refresh was successful and review recent refresh attempts.

The setup involves configuring Azure App Registration for Power BI API access, obtaining OAuth2 credentials, and inputting your dataset’s unique ID. Once configured, clicking ‘Execute workflow’ refreshes the dataset and fetches the latest refresh logs, simplifying data management for reporting teams.

This workflow is particularly useful for team members responsible for maintaining up-to-date BI reports, enabling them to trigger data updates instantly and check refresh logs efficiently, all within the n8n automation platform.