Question

OData Issue

0

Morning All, I'm looking at exposing some Entity data to other products such as PBI or MS Excel, I created a small entity with some 20 records or so to test and all is fine. When I create another Entity this time with 16,000 attributes the data doesn't seem to load even after waiting 45 minutes the headers are present but no data, the query continues to run saying 'Data Source Loading'. Gave I done something wrong or should I look at another way instead of using OData.

asked 2023-11-09

Stephen Meadows

2 answers

Sjors Schultz · Answer 1 · 2023-11-09

Hi Stephen,

Do you have paging enabled in the properties of your published Odata resource? This would help with large datasets and prevents your app running out of memory.

Stephen Meadows · Answer 2 · 2023-11-09

Hi All,

After my question earlier I changed the Paging but still had the same issue, I recreated the OData connection in Sandbox and the data appears in a matter of seconds.

I have published another entity to the DataHub but from 55,000 records it only pulls 1800 into either Excel or PBI, is there any reason for this limitation.