There have been frequent questions on timeout of the OData feed download from a Power Query (visible in the Advanced Editor), as visible on OData: Request failed: The operation has timed out.
A number of techniques with very large and/or small data downloads help to avoid these OData feed timeouts:
- Vermijd time-out fout bij Power BI OData download
- Pre-load data in OData-cache to avoid Power BI timeouts
Sadly, the first option requires each query to be opened in the Query Editor and the source step adapted to include a large timeout duration for the data feed. Luckily, each dataset only needs to be changed once.