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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,177
André Arnaud de Cal... 860 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
