Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Proud to be a Super User!
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.
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
Proud to be a Super User!
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.