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.
When you observe that it only receives around 1800 lines not the full 30000, does the response end with a nextLink?
No i'm looking at the data now and can see 1865 rows in Excel then followed by blank rows beneath it.