The following data sources are supported in Insights:
- Available hosted or registered feature layers from your content, groups, or organization
- Feature layers from ArcGIS Living Atlas of the World
- Microsoft Excel files (.xlsx)
- Comma-separated value files (.csv)
- Shapefiles (.zip)
- File geodatabases (.zip)(available in Insights desktop)
- GeoJSON files (.json, .geojson, or GeoJSON files in a .zip file)
- Map image layers
- Connections to Google BigQuery, Microsoft SQL Server, Oracle, PostgreSQL, SAP HANA, and Snowflake databases (available in Insights in ArcGIS Enterprise and Insights desktop). The following data types are supported:
- Spatial tables
- Nonspatial tables
- Relational database views
- Connections to enterprise geodatabases
- Connections to Microsoft OneDrive (available in Insights in ArcGIS Enterprise and Insights in ArcGIS Online). The following data types are supported:
- Microsoft Excel files (.xlsx)
- Comma-separated value files (.csv)
- Shapefiles (.zip)
- GeoJSON files (.json, .geojson, or GeoJSON files in a .zip file)
- Connections to Microsoft SharePoint (available in Insights in ArcGIS Enterprise and Insights in ArcGIS Online). The following data types are supported:
- Microsoft Excel files (.xlsx)
- Comma-separated value files (.csv)
- Shapefiles (.zip)
- GeoJSON files (.json, .geojson, or GeoJSON files in a .zip file)
- SharePoint subsites
- SharePoint document libraries
- SharePoint lists
Note:
Compressed files must use UTF-8 or CP437 character encoding.
Map image layers require that the Feature Access capability be enabled to support statistics. If statistics are not supported, you cannot use many Insights features, including creating charts. See Troubleshoot a map image layer for tips on how to enure that statistics are supported when you publish a map image layer. For more information, see Set map service properties and Editor permissions for feature services.
Map image layers must also have standardized query enabled. To enable standardized query, the layer must be shared as a dynamic service, rather than a tile layer.
Insights does not support the following:
- Multipoint geometries
- Multipatch geometries
- Feature layers from ArcGIS Online and ArcGIS Enterprise with a definition expression or feature layers that use an ArcGIS Arcade expression
- Query layers
- Feature layers with tracking enabled
- Datasets and enterprise geodatabases registered as versioned. You should unregister a dataset as versioned before using it in Insights.
Insights in ArcGIS Online does not support consuming on-premises feature services that are not Internet accessible.
Resources
Use the following resources to learn more about data in Insights: