https://community.fabric.microsoft.com/t5/Developer/Limited-to-20k-records-and-getting-odata-nextLink/m-p/2331661#M34324 <P>Pulling the fallowing Odata or Api source I get a limited amount of records (20k).</P><P>Using Postman to query Business Central's PostedSalesInvoice table I get the following&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="odata.nextLink limitation.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/668120i7CA59209FFA7220E/image-size/large?v=v2&amp;px=999" role="button" title="odata.nextLink limitation.png" alt="odata.nextLink limitation.png" /></span></P><P>&nbsp;</P><P>Table grows aroung 80k records per year. I will like to be able to pull all data. At the monet it takes over 1 hour to bring the data to Power Bi desktop and it will timeout on the web when trying to refresh the source.</P><P>&nbsp;</P><P>Thanks in advance</P> Thu, 10 Feb 2022 19:30:10 GMT LogixAdex 2022-02-10T19:30:10Z https://community.fabric.microsoft.com/t5/Developer/Limited-to-20k-records-and-getting-odata-nextLink/m-p/2331661#M34324 <P>Pulling the fallowing Odata or Api source I get a limited amount of records (20k).</P><P>Using Postman to query Business Central's PostedSalesInvoice table I get the following&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="odata.nextLink limitation.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/668120i7CA59209FFA7220E/image-size/large?v=v2&amp;px=999" role="button" title="odata.nextLink limitation.png" alt="odata.nextLink limitation.png" /></span></P><P>&nbsp;</P><P>Table grows aroung 80k records per year. I will like to be able to pull all data. At the monet it takes over 1 hour to bring the data to Power Bi desktop and it will timeout on the web when trying to refresh the source.</P><P>&nbsp;</P><P>Thanks in advance</P> Thu, 10 Feb 2022 19:30:10 GMT https://community.fabric.microsoft.com/t5/Developer/Limited-to-20k-records-and-getting-odata-nextLink/m-p/2331661#M34324 LogixAdex 2022-02-10T19:30:10Z https://community.fabric.microsoft.com/t5/Developer/Limited-to-20k-records-and-getting-odata-nextLink/m-p/2334516#M34354 <P>Does all of that data change over time or are the "older" records immutable and can be stuffed into a dataflow (for example)?&nbsp; Your API most likely supports a LIMIT/OFFSET concept (looks like a skiptoken there?) so you should use that.</P> Sat, 12 Feb 2022 03:13:23 GMT https://community.fabric.microsoft.com/t5/Developer/Limited-to-20k-records-and-getting-odata-nextLink/m-p/2334516#M34354 lbendlin 2022-02-12T03:13:23Z