https://community.esri.com/t5/arcgis-dashboards-questions/problem-to-get-data-in-arcgis-enterprise-from-a/m-p/1243211#M7145 <P>Hello,</P><P>We have created a Query Layer in ArcGIS Pro. It connects to a SQL Server database asking for the result of a SQL Server function (not a View). Its syntax is as shown below, where (7) indicates the number of days:</P><P>SELECT * FROM [&lt;database name&gt;][admin][&lt;function name&gt;](7)</P><P>In ArcGIS Pro this query works perfectly and we can see the result. It includes a geometry field (XY points) as SHAPE and some other attributes.&nbsp;</P><P>Later we load it as a Web Layer to ArcGIS Enterprise without any error. But when we try to create a Web Map and load this layer, the obtained table appears without any values in Map Viewer. No further information is provided by the software.</P><P>The final aim of this query is to get a dashboard.</P><P>The database is included in the data stores and it gets validated correctly.&nbsp;</P><P>What may be the reason of this error?</P><P>Thank your for your help.</P> Thu, 22 Dec 2022 10:37:26 GMT CarlosGarciaSoto 2022-12-22T10:37:26Z https://community.esri.com/t5/arcgis-dashboards-questions/problem-to-get-data-in-arcgis-enterprise-from-a/m-p/1243211#M7145 <P>Hello,</P><P>We have created a Query Layer in ArcGIS Pro. It connects to a SQL Server database asking for the result of a SQL Server function (not a View). Its syntax is as shown below, where (7) indicates the number of days:</P><P>SELECT * FROM [&lt;database name&gt;][admin][&lt;function name&gt;](7)</P><P>In ArcGIS Pro this query works perfectly and we can see the result. It includes a geometry field (XY points) as SHAPE and some other attributes.&nbsp;</P><P>Later we load it as a Web Layer to ArcGIS Enterprise without any error. But when we try to create a Web Map and load this layer, the obtained table appears without any values in Map Viewer. No further information is provided by the software.</P><P>The final aim of this query is to get a dashboard.</P><P>The database is included in the data stores and it gets validated correctly.&nbsp;</P><P>What may be the reason of this error?</P><P>Thank your for your help.</P> Thu, 22 Dec 2022 10:37:26 GMT https://community.esri.com/t5/arcgis-dashboards-questions/problem-to-get-data-in-arcgis-enterprise-from-a/m-p/1243211#M7145 CarlosGarciaSoto 2022-12-22T10:37:26Z