Share
Report
2We have a service ticket app that runs off batched data from an ODBC connection, flowing into a couple of data tables in an Excel file. We have an older ERP (Sage 100) system and are trying to go the free route as much as possible, and this has been the best route we have found. The Excel refreshes its data every hour through a Power Automate job. This setup has been working well for the past 4 months, but recently we've been getting the following error in our App randomly throughout the day:
"Error when trying to retrieve data from the network: No table was found with the name '%7B62BC42EC-949B-46F1-8423-5CF117D11F02%7D'. clientRequestId: ecde9660-1981-4357-afbf-a893b67f32f1 serviceRequestId: da428138-d127-40d0-9530-682a0ebad590"
The issue is that the mentioned table doesn't exist. It seems like it's looking for a totally random table. If I delete the Excel connector and reconnect, everything works fine for a while, but then the same error recurs. The Power Automate flow isn't having any issues, and when I open the Excel files, all of our real data tables are present and populated.
Any ideas on what might be causing this and how to fix it?
All responses (
Answers (
