https://www.biinsight.com/optimising-odata-refresh-performance-in-power-query-for-power-bi-and-excel/
Optimising OData Refresh Performance in Power Query for Power BI and Excel