Refresh of OData fails due to timeout

[Anonymous]

I have an OData connection to D365 from PBI. It fails to refresh due to 120 minute timeout on both scheduled and manual.

I have already trimmed the fetches to specific columns I need using OData url with $select.

I have tried OData v8.1, v9.0 and v9.1

I use OData.Feed(url, null, [Implementation="2.0"])

I am filtering rows to recent weeks using M Query.

When I refresh the dataset on PBI desktop it takes about 5 hours to refresh one entity.

What am I missing?

[Anonymous]

Over a few weeks of manual refreshing of the data and republishing, the last three weeks have been an exception.

The dataset refreshes by itself with no changes to the model deployed.

36 minutes, 34 minutes and 40 minutes have been the refresh times for last three weeks in reverse chrono.

I am assuming for now that the data reduced for this time period. Am observing for now.

My only other option still is go via a DW instead of directly connecting to OData Sources like D365. The model is not complex.

[v-lili6-msft]

hi, @Anonymous 

When I refresh the dataset on PBI desktop it takes about 5 hours to refresh one entity.

Obviously, you need to optimize the data model of this report.

You may refer to this article

https://www.powerobjects.com/blog/2018/01/11/power-bi-data-refresh-performance/

Best Regards,

Lin