How to Use Power Automate with Power BI

Your Power BI reports show you precisely what's happening in your business, but what if you could act on those insights instantly, right from your dashboard? By connecting Power Automate with Power BI, you can bridge the gap between analysis and action. This article will show you how to embed automated workflows directly into your reports and how to use triggers to keep your data perfectly in sync.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is Power Automate?

Before connecting the dots, let's quickly clarify the tools. Power BI is Microsoft's interactive data visualization and business intelligence tool. It helps you see and understand your data through dashboards and reports. Power Automate (formerly Microsoft Flow) is a service that helps you create automated workflows between your favorite apps and services. Think of it as a tool that performs repetitive tasks for you, like sending notifications, synchronizing files, and collecting data.

When you put them together, you transform your reports from passive displays of information into dynamic, interactive control centers for your business processes.

Why Combine Power BI and Power Automate?

Pairing these two powerful tools unlocks a new level of efficiency and interactivity for your business intelligence efforts. Instead of just viewing data, your team can trigger actions based on it instantly.

• Instant Action on Insights: Imagine a sales report highlights an underperforming region. Instead of screenshotting the chart and emailing the manager, you can click a button directly in the report to send a pre-formatted Teams message or email to the relevant stakeholders, alerting them to the issue.
• Streamline Business Workflows: You can create buttons in your reports that kick off entire business processes. For example, a marketing manager viewing campaign results could click to reallocate a budget, create a task in Planner for the design team, or send a performance summary to an executive.
• Data-Driven Notifications: Set up automated alerts that go beyond Power BI’s built-in capabilities. For example, trigger a push notification to your phone or a custom alert to a Slack channel when a specific Key Performance Indicator (KPI) crosses a critical threshold.
• Smart Data Refreshes: Rather than relying solely on a fixed schedule, you can trigger a Power BI dataset refresh based on a specific event. When a new sales record is finalized in your CRM or a crucial file is updated in a SharePoint folder, Power Automate can immediately start a refresh, ensuring your report always shows the latest data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Run a Flow from Your Power BI Report

The most direct way to integrate these tools is by adding the Power Automate visual to your report. This creates a clickable button that your users can press to run a workflow with data filtered from the report itself. Think of it as turning your data into a launchpad for action.

Let's walk through a classic example: a sales manager wants to notify a team in Microsoft Teams when a specific product category is underperforming based on the report filters.

Step 1: Add the Power Automate Visual

First, you need to add the Power Automate visual to your report canvas in Power BI Desktop.

1. Open your Power BI report.
2. In the Visualizations pane, click the ellipsis (...) and select Get more visuals.
3. Search for "Power Automate" and click Add next to the visual.
4. Once added, the visual's icon will appear in your Visualizations pane. Click it to add it to your report canvas.

Step 2: Add Data to the Visual

The visual needs data from your report to work with. This is how you pass information from your report slicers and filters into the flow. For our example, let's say we want to pass the Product Category and Total Sales value.

Drag the relevant data fields from your Fields pane into the Power Automate data field well in the Visualizations pane. Any fields you add here can be used as dynamic content within your flow. This is the magic that makes your automation context-aware.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Create Your Flow

Now it's time to build the actual workflow. With the visual selected on your canvas:

1. Click the ellipsis (...) in the corner of the visual and select Edit.
2. This will open the Power Automate interface directly inside Power BI. Click + New and then select Instant cloud flow. This creates a flow that is triggered by the Power BI button click. The trigger, "Power BI button clicked," is already set for you.
3. Click + New step. Search for the Microsoft Teams connector and select the action Post message in a chat or channel.
4. Sign in to your Microsoft Teams account if prompted.
5. Now, configure the action. You'll choose the Team and Channel where the message should be posted.
6. In the Message box, you can craft your notification. This is where you use the data you added earlier. Click inside the message box, and a Dynamic content panel will appear. You will see your Power BI data fields (e.g., 'Power BI data Product Category' and 'Power BI data Total Sales'). Select these to insert them into your message. Your message could look something like this: "Heads up! The '{Product Category}' category is underperforming with sales of only ${Total Sales}. Please review."
7. Give your flow a name (e.g., "Alert Team of Underperforming Category") and click Save. Then, click the back arrow to return to your report.

Step 4: Format and Test the Button

Back in Power BI, you can format your button like any other visual. Change the button text (e.g., "Notify Team"), font size, and colors to make it clear and intuitive for your users.

To test it, apply a filter to your report (for instance, filtering for a specific product category). Then, hold Ctrl + Click on the button in Power BI Desktop to run the flow. Check your specified Teams channel - your dynamic message should appear!

Method 2: Trigger a Dataset Refresh from a Flow

Sometimes you need your Power BI data refreshed now, not just on a schedule. Maybe a user just uploaded a new monthly sales CSV to a OneDrive folder, or a finance team member just updated a critical Excel file in SharePoint. Using Power Automate, you can trigger a dataset refresh the moment that event happens.

Step 1: Create a Flow in Power Automate

This process starts in the main Power Automate web portal, not within Power BI.

1. Go to make.powerautomate.com.
2. Click Create from the side navigation and select Automated cloud flow.
3. Give your flow a name, like "Refresh Sales Data on File Update".
4. Now, choose your trigger. This is the event that will kick things off. For example, search for "SharePoint" and select the trigger When a file is created or modified (properties only). You could also use a trigger from OneDrive, Google Sheets, or hundreds of other services.
5. Configure the trigger by specifying the SharePoint Site Address and the specific Library Name or folder you want to monitor.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Add the Power BI Action

Once the trigger is set, you add the action to be performed.

1. Click + New step.
2. Search for "Power BI" and select the action Refresh a dataset.
3. Sign into your Power BI account if needed.
4. Use the dropdown menus to select the Workspace and Dataset that you want to refresh. This needs to be a dataset in a workspace you have Contributor, Member, or Admin permissions for. Note: This refresh is subject to the same limitations as a manual refresh. For Pro licenses, you are limited to 8 refreshes per day, and for Premium, 48 refreshes per day.
5. Save your flow.

That's it! Now, the next time that specified file in SharePoint is updated, this flow will automatically run and tell Power BI to start refreshing your dataset, ensuring your stakeholders are always looking at the very latest information without any manual intervention.

Practical Use Cases to Inspire You

The possibilities are vast, but here are a few more ideas to get you thinking about how you can apply this to your own business:

• Client Management: In a customer dashboard, click a button next to a client's name to generate an on-demand performance report and automatically email it to them as a PDF.
• Inventory Control: When a report shows inventory for a product falling below a set threshold, a button can trigger a flow to create a reorder request in your ERP system or a task for the procurement team.
• HR Analytics: From an employee performance dashboard, a manager could click to initiate a positive feedback form or a coaching session request for a specific team member.
• IT Ticketing: An IT dashboard showing system outages could have a button to automatically create a high-priority ticket in Jira or ServiceNow with details about the affected system.

Final Thoughts

Integrating Power Automate with Power BI closes the loop between insight and action, empowering your teams to be more data-driven and efficient. By embedding workflows directly into reports or creating smart, event-based refreshes, you turn your analytics from something you simply look at into a tool you actively use to run your business.

Setting up workflows in Power BI or managing data pipelines across different systems can be complex, especially when your data isn’t just in the Microsoft ecosystem. Our goal with Graphed is to simplify this entire process for marketing and sales teams. Instead of configuring visuals and building flows, you can just ask a question in plain English, like "Show me my Facebook Ads ROI by campaign this month," and instantly get a live dashboard that pulls data from all your sources. We automate the connection and reporting so you can spend your time on strategy, not setup.