You can access the following layers in Insights. When you save your workbook, the datasets that were added are saved with it.
- Available hosted or registered feature layers from your content, groups, or organization
- Feature layers from ArcGIS Living Atlas of the World
- Excel files (.xlsx)
- Comma-separated value files (.csv)
- Map image layers
- Connections to Microsoft SQL Server, SAP HANA, PostgreSQL, and Oracle databases. The following data types are supported:
- Spatial tables
- Nonspatial tables
- Relational database views
- Connections to enterprise geodatabases
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.
Data from a spatiotemporal big data store can be added from your portal as a feature layer. You can create a feature layer from data in the spatiotemporal big data store using the Copy to Data Store tool from the GeoAnalytics Tools in Portal for ArcGIS or ArcGIS Pro. GeoAnalytics Tools and the spatiotemporal big data store are only available if your ArcGIS Enterprise deployment includes GeoAnalytics Server.
Insights does not support the following:
- Multipoint geometries
- Adding data from a secured service if the credentials (user name and password) were not stored when the item was registered
- Query layers