Announcements
No record found.
Hi - I'm looking to bring Odata feeds into a Bi tool. I'm able to pull in the first page of 1000 records but no additional pages.I'm a newbie to this and can reduce the data set with the $top instruction in the URL but I'm unable to pull in further pages.How am I able to bring in all data from the set?Thanks in advanceJohn
Hi Johnny_321,
I think pagination can be achieved by using skip option. But it's not a good idea to query a lot of data through oData.
Take a look at BYOD docs.microsoft.com/.../export-entities-to-your-own-database
data/CustomersV3?$top=1000 - First page
data/CustomersV3?$top=1000&$skip=1000 - Seconds page
data/CustomersV3?$top=1000&$skip=2000 - Third page
Morning Sergei,
Thanks for taking the time to respond :-)
The BYOD link looks like that could be incredibly helpful.
All the Best
Johnny
As Sergei mentioned, OData supports pagination, if you look at response in the end of it you will see
"@odata.nextLink": https://*****.operations.dynamics.com/data/CustomersV3?$skip=10000&$top=10000"
using it you can get next 10000 records. However, as Sergei mentioned, BYOD or Data Lake could be better approach for reporting and high volumes of data. Here is compassion between DMF and OData and common usage scenarios docs.microsoft.com/.../integration-overview
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 563 Super User 2026 Season 1
Giorgio Bonacorsi 401
Diego Mancassola 259
