Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.