AnsweredAssumed Answered

Running SQL Server Queries

Question asked by deleted-user-8TVt6oc0ewsX on May 29, 2019
Latest reply on May 30, 2019 by SChavez-esristaff

I have a spreadsheet that has 2 MS SQL Server Queries with about 2000 records each.  The queries run quickly and the map I created plots the points quickly.  If I save the spreadsheet and then reopen and refresh the queries each query takes up to 2 minutes to run and update the map (I have "Refresh data when opening the file" toggled ON).  I found a python script to run REFRESH ALL to refresh the data offline.  However when I then try to open the spreadsheet after running the script I get an immediate error, "An error has occurred" and the map doesn't open.  I usually saw this error if I did not have "Enable background refresh" enabled for the query.  I think the error has to do with verifying sign-in to AGOL)

 

My python updating would solve my problem if I can get past this error (I would disable the "Refresh data when opening the file).

 

Does anyone have a suggestion to either fix the problem or improve performance of refreshing a query to ensure users see the latest data when they open the spreadsheet.

Outcomes