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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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