• 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

Announcing Data Refresh APIs in the Power BI Service

June 24, 2017   Self-Service BI

Power BI enables anyone to get insights from data in minutes. But, to unlock the full potential of Power BI, the data needs to be kept up-to-date. Scheduling dataset refreshes in Power BI allows you to do this, regardless of how your dashboards and reports are distributed and consumed. However, we’ve heard feedback that it can be difficult to manage the increasing number of datasets and refresh schedules as an organization scales up Power BI.

Today, I am excited to announce the general availability of new APIsfor managing data refresh in the Power BI service. These new APIs will allow you to programmatically trigger data refreshes and retrieve refresh history for any dataset that you own. With these versatile new tools, you’ll be able to easily automate and scale out Power BI data refresh management – no more clicking through dataset settings or flipping through refresh histories. In addition, these APIs open the door to integrating data refresh into your existing ETL or deployment processes. You could, for example, trigger Power BI data refresh as the last step in your Azure Data Factory ETL pipeline. And, as an ISV, you can easily manage the data for all your embedded analytics solutions.

We’re very excited about what you can accomplish with these new tools. Read on for an overview of how to use them, and all these tools can do for you. Or, jump right into the documentation or sample code.

Getting Started

To trigger refresh for a dataset in the Power BI service, simply make the following HTTP Request. You can craft this request using an HTTP utility like Fiddler, or by running our sample code.

Some additional tips:

  • Once you make the request, a data refresh will immediately be kicked off in the Power BI service
  • This works for any dataset imported to the Power BI service that you own
  • To get the group ID and dataset ID, you can make a separate API call, or simpler yet, just navigate to dataset settings in Power BI. The URL will have both the group ID, and the dataset ID.
  • Like all requests to the Power BI REST API, you will have to attach an AAD access token. For more information, see the Power BI REST API authentication documentation.
Note: if the dataset is not in a workspace assigned to Premium capacity, then you will be limited to eight refreshes per day. Datasets in workspaces assigned to Premium will support up to 48 refreshes a day.

You can also check refresh history for a particular dataset by making a GET request to the same endpoint.

The service will then return a list representing the refresh history for that dataset, with the same information that you’d see in the refresh history UI in the service.

{ "value":[
  {
    "id":252103441,
    "refreshType":"Scheduled",
    "startTime":"2017-06-16T08:02:05.69Z",
    "endTime":"2017-06-16T08:14:29.61Z",
    "status":"Completed"
  },
  {
    "id":251845601,
    "refreshType":"ViaApi",
    "startTime":"2017-06-16T00:10:46.087Z",
    "endTime":"2017-06-16T00:10:53.04Z",
    "status":"Completed"
  },
// and etc…
}

Some additional tips:

  • You can use the ?top parameter to limit the number of entries you get back – e.g. for just checking on the latest refresh that you triggered with the API
  • Unlike the API to trigger refreshes, this API is not limited to being called eight times a day in non-Premium capacity

Next steps

We’re excited to see what you can accomplish with our new APIs. Check out our resources below to get started. And as always, please leave feedback or questions below or in the community – we’d love to hear from you!

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Announcing, APIs, data, Power, Refresh, service
  • Recent Posts

    • Accelerate Your Data Strategies and Investments to Stay Competitive in the Banking Sector
    • SQL Server Security – Fixed server and database roles
    • Teradata Named a Leader in Cloud Data Warehouse Evaluation by Independent Research Firm
    • Derivative of a norm
    • TODAY’S OPEN THREAD
  • Categories

  • Archives

    • April 2021
    • March 2021
    • 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