1

I have scheduled query for a dataset in Power BI.

In case of a refresh failure, I want Power BI to "retry" to refresh the data again, up to 5 times.

Is there a way to do it?

Super Jade
  • 5,609
  • 7
  • 39
  • 61
user2671057
  • 1,411
  • 2
  • 25
  • 43

1 Answers1

2

For the time being it doesn't seem possible as confirmed by this post. You can play with the "Command time out in minutes(optional)" in your query when creating your data source as noted in the comments. Under Advanced options.

If the timeout is left blank the default is 10 minutes. So if the issue is that your queries are timing out this may be the solve for you.

Another workaround is that you can schedule your data source to update multiple times at half hour increments. Like so. Note that depending on how big your data set is this may place a burden on the server you are pulling from. If that is the case then looking into incremental refresh would be your next go to.

Hope this helps.

Sizzling_Boots
  • 68
  • 6