Odata Query refresh takes a long time for minimal records

Like (2) Share

Report

Posted on 31 Jan 2025 10:20:59 by CU31011009-0

Hi,

I'm looking at getting one sales order from Finance and Operations through OData into Excel using power query.

I have filtered and selected just the columns I need using the following url - masked information is enclosed in #

#environment#/data/SalesOrderLinesV3?$expand=SalesOrderHeader($select=InvoiceCustomerAccountNumber,OrderingCustomerAccountNumber)&$select=ItemNumber, DeliveryAddressName, OrderedSalesQuantity, LineDescription, SalesOrderNumber, SalesOrderHeader&$filter=SalesOrderNumber eq ' #variableforsalesorder#

When I run this query it always queries 41.9MB of data regardless of how many rows it returns and takes a while to refresh.

Is there something I am doing wrong?

Why does it query such a large amount of data compared to what I get back?

Thanks

Tristan

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

All responses (2)

Answers (1)

Verified answer

CU31011009-0 6 on 02 Feb 2025 at 15:13:04

Like (0)

Report

Odata Query refresh takes a long time for minimal records

Hi :@Waed Ayyad, thanks for your response.

I'm trying to return a single sales order which is likely to be 1-5 lines.

I don't understand why this takes around 10-20 seconds to return.

Thanks
Suggested answer

Waed Ayyad 7,713 Super User 2025 Season 1 on 02 Feb 2025 at 14:53:30

Like (0)

Report

Odata Query refresh takes a long time for minimal records

Hi,

There is a limit in OData call, the max limit is 10K, if you have more than 10k you should use OData pagination.

Check the following link:

https://alexdmeyer.com/2019/08/06/data-entity-filtering-in-dynamics-365-for-finance-operations/

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue