- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Can aggressive retry on OData requests be reduced?

We provide a proxy for 75+ (cloud)platforms using OData4. This enables Power BI, Power Query and ADF to easily exchange data with all these platforms.
However, when an error occurs, Power BI tries each table in total approximately 10 times, typically all without success. With a report with 10 tables, 100 OData4 requests are executed.
For instance, we have made a OData4 source unavailable such that it raises a permanent error (see picture). On Power BI Desktop with data preview, it first tries a number of times WITH $top=1000 and then more WITHOUT $top=1000.
The request and headers for the rest are all the same:
Request /invantive-exact-online/odata4/ExactOnlineDataDictionary.DataDictionary.IncrementalLoadEventLogEntries@eol
Headers:
Accept: application/json;odata.metadata=minimal;q=1.0,application/json;odata=minimalmetadata;q=0.9,application/atomsvc+xml;q=0.8,application/atom+xml;q=0.8,application/xml;q=0.7,text/plain;q=0.7
Accept-Encoding: gzip, deflate, Authorization: (header present), Host: localhost:44301
User-Agent: Microsoft.Data.Mashup (https://go.microsoft.com/fwlink/?LinkID=304225)
MaxDataServiceVersion: 3.0
OData-MaxVersion: 4.0
Some users flood our servers sometimes with thousands of requests and recently one specific user downloaded 184 GB Brotli-compressed data (2,4 TB) on a Saturday-morning, all with the same error due to a crash in ADF.
Is there a known way to convince Power BI that some OData4 errors are persistent and that it should backoff some time?
We have tried varying the HTTP status and the content of the standardized OData4 JSON format, but with no luck.
It would be great when the OData4 producer could say: this is a permanent error, try again tomorrow or try again in a few seconds.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Michael_Tucker on: New Card Visual inadvertently switching on values ...
- Gandalf12345 on: Copying Table with Filters is Ignoring Filters
- DNilsson on: March 2025 Update - Error fetching data for this v...
- Knox_DataMan on: Snowflake connector isn't showing views after Marc...
- Tomasz_Skoczyla on: March 2025 update - Style preset error
- KrishnaKishoreK on: Conditional Formatting - Field Value not working a...
- jbongjbong on: Stretched App's Logo in Home Page "Recommended"
- pedrodr99 on: Button Slicer - Label - Color change not working
-
v-xiaoyan-msft on: Default Chart - Shape Map Is Not Working As Expect...
-
v-xiaoyan-msft on: Error (Exception from HRESULT: 0x80070002)
- New 7,874
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,150 -
Data Modeling
4,094 -
Dashboards
4,082 -
Gateways
2,103 -
Report Server
2,099 -
APIS and Embedding
1,951 -
Custom Visuals
1,770 -
Content Packs
521 -
Mobile
353 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1
@monty
We should not have such a method. As long as Odata doesn't throttle the request from Power BI, Power BI will retry several times to complete operation and I haven't found a statement on how many times retries for each table Power BI will carry when connection fails. I will continue to look for it and sync with you here when there is any update.
Best Regards,
Community Support Team _Caiyun