Add automatic retries for failed data refreshes for datasets

[daniel_willen]

Hi,

I would like a "retry" function for Power BI Datasets. If the dataset fails to refresh I want it to retry up to X amount of times. This would be quite a simple but very useful feature to develop as it would fix many intermittent issues that can occur when datasets are refreshed. Data Factory and pipelines features a similar function, where you can input the number of attempts made by the service before it considers it a "fail to refresh".

The background for this request is that a lot of Microsoft customers are using your Export To Datalake feature to export CSV data to their datalake and read it in Power BI.

When tables records are frequently updated or deleted in finance and operations apps, you might notice a read/write contention on CSV files, and this error might occur. This issue occurs when the Synapse serverless SQL service queries a CSV file as it's being updated. In many cases, you might be able to fix this issue by retrying the query.

This means that sometimes the Power BI Refresh will fail at random. A quick and easy solution is just for the report to retry before failing.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/finance-data-azure-data-lake#when-i-read-data-files-by-using-synapse-serverless-i-notice-an-intermittent-error-unexpected-end-of-input-within-record-at