Pete Alberts's Likes

Your latter approach is far from ideal, because you fetch many records that you don't need.

The former approach is good, but you didn't enable paging: myQueryRun.enablePositionPaging(true). Also, make sure that your query is sorted in some way…

I'm finally out of the woods. I did build the model and synced the db. From that I did a metadata request https://[root url]/data/$metadata which took a bit more time to return the response, maybe because it wasn't cached as yet. In the response body…

Hi Prem,

When you used 'Open in Excel', you can set the Dynamics 365 connector in a design mode. Is the field available in the list for your changed entity?

Your customizations can definetely cause the problem. 

You could try to remove them temporarily and see if it works faster.

And you can also share more details about your adjustments with us if you need more detailed opinions.