Dataverse limitation: limit 83 MB

[Rami_Aziz]

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.

[amitchandak]

@Rami_Aziz , refer to the work around given at

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tab...

[Rami_Aziz]

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.