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
Dan2
Helper I
Helper I

Is a data refresh required after changing the datasource connection using the powerbi API?

Here is the scenario:

 

1. I use the api (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasourcesingroup) to change a dataset connection (database/server/login credentials). This works fine.

2. The reports that use this datasource that was updated in above step are using import mode. So I need to get the new data into the report. 

So here is the question. I have noticed sometimes that the datasource will automatically start a refresh after calling the UpdateDatasources and sometime will not. So programmatically I am always calling the API (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdataset) to do data refresh after the update. But based upon the help documentation (https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasourcesingroup) it states something about waiting 30 minutes before doing a refresh, but I am not sure if this applies?

 

So is it ok to call a refresh after doing a datasource connection update, or do I need to wait 30 minutes, or will it automatically refresh after some time. Please note, I am not discussing dataset scheduling in this post ad I am already doing this. I am only addressing the issue after a datasource connection update has been just completed using the API.

 

Thanks for the help.

1 REPLY 1
Bbooogie
Advocate I
Advocate I

Hi!

 

You can see in the datasets tab in Power BI Service when the next refresh will happen.

 

In my case i also called the refreashdataset after an update of the datasource and hit the limit very quickly. So i just leave it for the automatic refresh for now.

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.