I’d be interested to know if there is something not optimized with your query, or if accessing the BAQsvc is just faster.
I tested your URL in my environment(changing parameters accordingly) It took 30sec for 1k, and 17 minutes for 30k.
During those 17 minutes I made an equivalent BAQ, and accessed it through REST, and it took like 10 seconds to load the 30k rows of data.
We regularly pull large BAQ datasets through REST into PowerBI… I have a BAQ to grab Part Data such as description, item type, group, several attributes, costing facts, supply and demand facts etc. That pulls like 93k rows, and it usually takes 1-2 minutes at most.
This is the URL we use:
No Parameter:
https://centralusdtapp24.epicorsaas.com/saas749/api/v2/odata/{Company}/BaqSvc/{BAQ Name}/Data?api-key={ApiKey}
With Parameter:
https://centralusdtapp24.epicorsaas.com/saas749/api/v2/odata/{Company}/BaqSvc/{BAQName}/Data?{ParameterName}='{ParameterValue}'&api-key={ApiKey}