OData Issue

0
Morning All,   Just a quick one on OData connections please, I have exposed an Odata Source and published an entity with 30000 line items.   I have tried it with and without authentication but when I attempt to retrieve the data in either Excel or PBI the headers come through but nothing else.   I have tried to access via Sandbox but only receive around 1800 lines not the full 30000, I have enabled and disabled the paging but still the issue remains.   I can see in the catalogue that the source is available Internal only so a potential issue can anyone advise how to change tis to External.   If someone could advise please as we have a project nearing completion that cant go live until the data is retrievable.    
asked
2 answers
0

When you observe that it only receives around 1800 lines not the full 30000, does the response end with a nextLink?

answered
0

Hi Joost,

 

No i'm looking at the data now and can see 1865 rows in Excel then followed by blank rows beneath it.

answered