Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Tom-ADV
Frequent Visitor

Refresh report data using REST API

Hi, we are developing an app that uses Power BI to generate reports. The data we are using comes from a local MySQL server hosted on our local network. The PBI reports use the tables from the MySQL database, which are regularly updated. Naturally, we need to update the reports with fresh data as it becomes available. Typically, the "refresh" button does the job, but we need to automate this process.

 

We recently started using the PBI REST API, and while browsing the documentation, I couldn't find the term "refresh data." So, I am not sure if "update report content in group" is what I am looking for...

https://learn.microsoft.com/en-us/rest/api/power-bi/reports/update-report-content-in-group

If there are multiple steps involved, I would very much appreciate it if someone could list them.

Thanks!

1 ACCEPTED SOLUTION

Hey,

Yes,whenever you publish a report a dataset gets craeted along with it

NandanHegde_0-1681185739195.png

Since your source is present within a vnet, in order for your report to referh in power BI service (cloud), you need to set up a gateway between your datasource Vnet and powerbi cloud which is on premises gateway




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

View solution in original post

5 REPLIES 5
NandanHegde
Super User
Super User

Hey,

Can you be a little clear on your ask?
Is your dataset following an incremental refersh or full refresh?

The below blog explains automation of refresh(full) via ADF

https://datasharkx.wordpress.com/2022/11/07/refresh-power-bi-dataflow-dataset-from-azure-data-factor...

 

Dataset API to refresh :

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset

 




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Hey @NandanHegde , we are currently consume the data by:

Get Data -> MySQL databae -> Connect -> Credentials -> Connect -> Navigator -> Select Tables -> Load
To refresh the Data we simply clicked "Refresh" and the new data would be introduced to the report.

We wish to automate the above proccess and could  be wrong about the whole approach...

Hey, The above manual approach you are suggesting is being done in your local system via PBIX file refresh.

 

You need to publish the report to Power BI service post which you can leverage REST APIs to automate the refresh as stated in above blog.




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

@NandanHegde , Yes, we did publish the report. It is available online and can be accessed externally by anyone with a link to that report.

I just can't figure out the equivalent API method to trigger that refresh functionality, if such a thing even exists, we don't use a "DataSet" object. How can I trigger a refresh in this case?

 

EDIT:
@NandanHegde , Well, it seems like there is a dataset which I wasn't aware of that is being created after publishing a report. But this dataset has to be configured to get the data via an On-premises Gateway in order to refresh using the API.

Hey,

Yes,whenever you publish a report a dataset gets craeted along with it

NandanHegde_0-1681185739195.png

Since your source is present within a vnet, in order for your report to referh in power BI service (cloud), you need to set up a gateway between your datasource Vnet and powerbi cloud which is on premises gateway




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.