Have been using the Splunk ODBC driver v3.11 (64-bit) to pull time-series event data from a saved search (report) into Excel for manipulation. Has been working perfectly for over a month but today Excel has suddenly began complaining about missing columns when executing a refresh:
"[Expression.Error] The column 'XXXX' of the table wasn't found."
Sure enough, the preview in Power Query shows those columns missing. Sometimes I can refresh and they'll reappear, but mostly they don't. The search on the Splunk side runs fine and includes all the columns Excel complains about.
I've been troubleshooting by time bounding the search to see if some bad data has crept it but am not finding any pattern yet.
Is there any way to enable debug logging for the ODBC driver? Nothing obvious jumps out at me in the Windows ODBC configuration GUI.
Open to other ideas as well - may have to switch back to a two step CSV export and subsequent load into Excel - less than ideal.
Thanks in advance!
