OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Return records size cannot exceed 83886080

[lionx]

I am trying to get data from a table on Dynamics 365 but get the error below"

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: An error occurred while receiving the HTTP response to https://xxx.crm6.dynamics.com/xrmservices/2011/organization.svc/web?SdkClientVersion=9.2.49.832. This could be due to the service endpoint binding not using the HTTP protocol. This could also be due to an HTTP request context being aborted by the server (possibly due to the service shutting down). See server logs for more details. RequestId: TDS;376306fe-a2ce-45dd-81e7-d8ecd6878f00;2 Time: 2023-01-17T04:42:00.2048624Z.

Actually, this data is just 40000 rows. How to deal with that? 

[lionx]

Hi @pratyashasamal ,

Thank you for your response. I have applied this solution before and it worked well. But what I want is to get the whole data from the original table as it is associated with all related tables. 

[pratyashasamal]

Hi @lionx , 
Right now are you having Direct Query Storage mode or Import Mode Storage mode ?
With Direct Query you can have upto 1 million rows .
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[pratyashasamal · Accepted solution]

Hi @lionx ,
TDS has a result set size limit of 80 MB.
To work around this limit, optimize the query adding filters and dropping columns so that the query returns less data.
Please follow this link for more information : https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tab...
Thanks ,

Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C