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”.
How can I take advantage of Insights for ArcGIS if I can’t work with 705.000 records?
What do you advise me?