AnsweredAssumed Answered

Errors when trying to work with 705,000 records

Question asked by ersanchezesri-co-esridist Employee on Apr 25, 2018
Latest reply on Sep 17, 2018 by Steve.Lewis_noaa

I’m working in Insights 2.2.1 for ArcGIS Enterprise 10.6, I connect to database table in SQL Server 2016, this table has 705.000 records. When I try to explore data in a map card (enable location), the system shows me a message “The dataset contains too many records: Try reducing the size of your dataset by filtering it or adding less than 100.000 entities”. I try to adding the same data as Excel or CSV, the system return message “Error loading the file. A maximum file size of 100 MB is allowed”. As last choice I publish the table as service of points (feature layer hosted), add in a map card and the system try to work but show a message “An error has occurred”.


The question:


How can I take advantage of Insights for ArcGIS if I can’t work with 705.000 records?  


What do you advise me?




Edward S.