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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Frequent Visitor

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Kudoed Authors