Forum Discussion

Caroline_1900

Frequent Visitor

5 years ago

Solved

Model Size

Hello World, Newbie User here. I need help with a big dataset. Getting data from the DataVerse. After removing the PowerBi plumbing and unwanted columns, the table has 101 columns and 508,628 ro...

Need Help

MisterFry
5 years ago
The ODBC enpoint to Dataverse has an 80 Meg limit on the data it can return.

You either need to chop up your query into smaller queries, or use another method to export the data.
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query

Anonymous

Not applicable

4 years ago

DataSource.Error : Microsoft SQL : Return records size cannot exceed 83886080. Make sure to filter result set to tailor it to your report.
RequestId: TDS;c3c748a8-fbbb-4e96-b53c-f4101e4f7fe4;2
Time: 2021-11-18T15:50:41.3471257Z
Détails :
DataSourceKind=CommonDataService
DataSourcePath=itesoft.crm4.dynamics.com
Message=Return records size cannot exceed 83886080. Make sure to filter result set to tailor it to your report.
RequestId: TDS;c3c748a8-fbbb-4e96-b53c-f4101e4f7fe4;2
Time: 2021-11-18T15:50:41.3471257Z

Forum Discussion

Model Size

Related content

Size limit per Semantic model

How semantic model size is increasing?

real size of data model

Power BI semantic model size limitation in F64

increase file size