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.
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.
@Rami_Aziz , refer to the work around given at
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.
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.
User | Count |
---|---|
47 | |
27 | |
23 | |
13 | |
8 |
User | Count |
---|---|
73 | |
51 | |
45 | |
16 | |
12 |