https://community.esri.com/t5/arcgis-dashboards-questions/cannot-access-data-with-gauge-element-in-dashboard/m-p/1064085#M4629 <P>Closing the loop on this issue in case its helpful to anyone in the future.</P><P>I checked the ArcGIS Server logs when the Gauge element produced "Cannot Access Data" and it recorded the following error:</P><UL><UL><LI><SPAN>Geodatabase error: Insufficient permissions[42000:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'XXX_evw', database 'XXX', schema 'XXX'.]. Insufficient permissions.</SPAN></LI></UL></UL><P><SPAN>Turns out the arcgis server user had permissions to the feature class in the enterprise geodatabase, but not the versioned view. In ArcCatalog, I regranted SELECT privileges on the feature class to the arcgis server user and now I can used the Gauge element with the layer.</SPAN></P> Wed, 02 Jun 2021 14:42:55 GMT Anonymous User 2021-06-02T14:42:55Z https://community.esri.com/t5/arcgis-dashboards-questions/cannot-access-data-with-gauge-element-in-dashboard/m-p/1060410#M4565 <P><SPAN>I am trying to create a dashboard that references data in an enterprise geodatabase to monitor our progress as the data is edited. But, when I use the data as a source for the Gauge element in the Dashboard it says "Cannot access data" and the "Loading Data" keeps spinning. I need help figuring out why.</SPAN><BR /><BR /><SPAN>The source data is layer from a map service in ArcGIS Server. The map service was published to reference source a feature class in an enterprise geodatabase. The map service has other layers as well and those work just fine in the Gauge element of a dashboard.</SPAN><BR /><BR /><SPAN>Some additional information/troubleshooting I've tried:</SPAN><BR /><SPAN>1. I can click show preview of the data and it shows the data in table form</SPAN><BR /><SPAN>2. The map service that the data is in has other layers, if I use those layers as a source for the Gauge element they load just fine.</SPAN><BR /><SPAN>3. If I publish the feature class as a hosted feature service in ArcGIS Online the Gauge will work. But, I don't want the data source to be a copy in ArcGIS online, I want it to reference the original data from the enterprise geodatabase.</SPAN><BR /><SPAN>4. The data works with other elements, like the List in the dashboard.</SPAN><BR /><BR /><SPAN>I have a feeling it is something specific about how the Gauge element queries the data that isn't working with this layer in the map service. But, can't figure out what.</SPAN></P> Fri, 21 May 2021 13:58:39 GMT https://community.esri.com/t5/arcgis-dashboards-questions/cannot-access-data-with-gauge-element-in-dashboard/m-p/1060410#M4565 Anonymous User 2021-05-21T13:58:39Z https://community.esri.com/t5/arcgis-dashboards-questions/cannot-access-data-with-gauge-element-in-dashboard/m-p/1064085#M4629 <P>Closing the loop on this issue in case its helpful to anyone in the future.</P><P>I checked the ArcGIS Server logs when the Gauge element produced "Cannot Access Data" and it recorded the following error:</P><UL><UL><LI><SPAN>Geodatabase error: Insufficient permissions[42000:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'XXX_evw', database 'XXX', schema 'XXX'.]. Insufficient permissions.</SPAN></LI></UL></UL><P><SPAN>Turns out the arcgis server user had permissions to the feature class in the enterprise geodatabase, but not the versioned view. In ArcCatalog, I regranted SELECT privileges on the feature class to the arcgis server user and now I can used the Gauge element with the layer.</SPAN></P> Wed, 02 Jun 2021 14:42:55 GMT https://community.esri.com/t5/arcgis-dashboards-questions/cannot-access-data-with-gauge-element-in-dashboard/m-p/1064085#M4629 Anonymous User 2021-06-02T14:42:55Z