topic Dataverse limitation: limit 83 MB in DAX Commands and Tips

Dataverse limitation: limit 83 MB

Rami_Aziz — Mon, 30 Jan 2023 11:48:23 GMT

Hi Everyone,

im trying to connect to CRM using dataverse and i know the limitation of 83 MB, is there any other ways or way around i can connect to CRM or using different connector to pass this limitation ?

Error:

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Return records size cannot exceed 83886080. Make sure to filter result set to tailor it to your report.

note: I read the documentation and i dont prefer to chop or make it small queries.

Thanks.

Re: Dataverse limitation: limit 83 MB

amitchandak — Tue, 31 Jan 2023 02:15:51 GMT

Rami_Aziz , refer to the work around given at

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs=Dataverse#error-message-return-records-size-cannot-exceed-83886080

Re: Dataverse limitation: limit 83 MB

Rami_Aziz — Tue, 31 Jan 2023 07:27:05 GMT

Thank you for your reply,

The issue is that i got is a table with 128 columns and i cant leave any columns or take it out,

i beleive selecting specific column is similar to tailoring the report which it will work. but after some certain columns again the error will come

Note: the same issue will accure when you select all the columns, so its not the solution.