Forum Discussion
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...
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
Thanks Mister Fry! I understand now.The file was indeed much larger than 80MB.
The problem lies with the documentation of the error message: "Return records size cannot exceed 83886080" led me to believe the error had something to do with the total number of records, not the total file size .
So much to learn, so little time.
Thank you again for your knowledge and experience.