• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Refresh your Power BI dataset using Microsoft Flow

October 18, 2019   Self-Service BI

When speaking with customers about how they’ve used Power BI to improve collaborative business processes in their organization, we often hear that Power BI is used to summarize and visualize data that many end users are entering into tools like Excel files, SharePoint lists, or the Common Data Service.  Business processes like managing a team’s budget requests, planning hiring activities, and evaluating marketing campaigns can all fit this pattern.

With these sorts of processes, users often expect Power BI reports to be updated as soon as they enter data in underlying systems. Power BI’s existing fixed refresh schedules are not sufficient to accomplish this and manually refreshing the Power BI dataset each time your access a report adds extra steps and creates confusion.

Today, we are making scheduling of refreshes much more flexible to improve how Power BI works in processes like the ones described above. Specifically, we have added a new Refresh a dataset action to the Power BI connector for Microsoft Flow. Now, you will be able to trigger dataset refreshes based on hundreds of Flow triggers. Whether your trigger is based on changes to items in your SharePoint list or updates to an Excel file in OneDrive or SharePoint Online or a complex day and time schedule, there are dozens of use cases for this action.

Excited? Read on for a full tutorial of using the new refresh a dataset action to automate refreshing a Power BI report based on changes to a SharePoint list. Or, head on over to  Flow to try it out for yourself.

Tutorial: Trigger dataset refresh for SharePoint lists or OneDrive Excel files with Flow and Power BI

In this tutorial, we will create a Flow that triggers a dataset refresh whenever items in a SharePoint list are updated.

Consider an example where you are the office administrator for Northwind Traders and you have been given the responsibility of ensuring the office is well stocked with office supplies, by monitoring inventory, placing new orders, and maintaining the overall budget for the team. You might have a report that looks something like this:

Furthermore, imagine that various employees in the company have access to a SharePoint list to report supplies that are getting low in their parts of the office:

To ensure you have an accurate picture of your supply requests and budget levels, any requests made on this SharePoint list should immediately reflect in the report. Instead of having to manually refresh your dataset each time you or someone else views the report or wait until the next scheduled refresh, you can easily automate this process using the new dataset refresh action in Flow.

To get started, navigate to Flow. Sign in, and then go to My Flows, then choose + New, and select + Automated – from blank from the drop-down. You should see the following:

Go ahead and give your Flow a name and select a SharePoint trigger depending on your use case. In this example, since we want the Flow to trigger when there’s a new row added to the list, choose When an item is created or modified.

Next, click on the + New step button, then enter ‘power bi’ in the search box. You should see a list of actions like below:

Then choose the new Refresh a dataset action.

Now, we’re at the last step of the Flow: Select the name of the workspace, then the name of the of the dataset that you want to trigger the refresh for. In our case, we have chosen Northwind Traders workspace and Northwind Budget Tracker dataset.

And that’s it! Select Save and ensure your Flow is turned on. Now, whenever there is a new supply request made in the SharePoint list, your budget tracker dataset should automatically refresh.

Going back to our budget tracking example for Northwind Traders, if there is a new request made to the Supplies Request SharePoint list that exceeds the budget:

Your flow will trigger and the dataset will automatically update. Considering this individual, placed an order for 500 4K monitors, you will certainly know when you’re out of budget next time you visit the Northwind Budget & Supplies tracker report:

Next steps

  • Try out the feature! Head on over to Flow and use the new refresh action to automate your refreshes
  • Existing limits on refreshes apply when running the refresh dataset action in Microsoft Flow.  For datasets in shared capacity used by Power BI Pro, your refresh action is limited to eight refreshes per day (including refreshes executed via Scheduled Refresh). In Premium capacities, there is not limitation on the number of refreshes per day, although you are limited by the available resources in your capacity.  If there are not sufficient resources, the refresh execution may be throttled until the load is reduced. If this throttling exceeds 1 hour, the refresh will fail.
  • For more ideas on Flows, check out some of our existing Flow templates that allow you to add data from Flow into a Power BI dataset or use data alerts to trigger a Flow whenever the data changes. In the coming weeks, we’ll also be adding several Flow templates with the new refresh a dataset action, including the one featured in the tutorial above – so stay tuned for that.
  • Have any feedback? Have an idea for another way that Power BI can connect to Flow? We’d love to hear it! Please leave comments below or in the Power BI community forums

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Dataset, Flow, Microsoft, Power, Refresh, using
  • Recent Posts

    • WHEN IDEOLOGY TRUMPS TRUTH
    • New Customer Experience Needs and Commerce Trends for 2021
    • A data transformation problem in SQL and Scala: Dovetailing declarative solutions
    • George Wallace Joins Laverne Cox For Comedy Titled ‘Clean Slate’
    • How Microsoft Azure DevOps and Dynamics 365 CRM Work Together to Improve Service Responsiveness
  • Categories

  • Archives

    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited