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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |