Add automatic retries for failed data refreshes for datasets
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
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Restrict preview in Power Query to configurable number of rows
Going through transformations steps in Power Query and inspecting the preview of single steps can take very long depending on complexity of transformations and data volumne. It would be nice to be a...ITManuel5 hours agoResponsive ResidentNew5Views0likes0CommentsAdd selective sync to OneLake File Explorer and allow Lakehouse sync to Files only
Idea Please add a selective sync feature to OneLake File Explorer so users can choose exactly which Fabric items are synchronised to their local machine. Today, OneLake File Explorer surfaces...JP899115 hours agoKudo CommanderNew574Views6likes1Comment