Forum Discussion
Repeated refresh failure
and BOOM, just like that . . . I fixed it. It was the gateway. I uninstalled, reinstalled, and revalidated my credentials. Now it is working.
May not matter, but personal or enterprise gateway? Is Excel file on-premises in a folder or OneDrive? SQL Server on-premises?
Sorry, want to see if I can recreate exactly.
Sorry, I should have provided more details. The excel file is in one drive. The sql server database is on premise. The refresh failure is occuring within a group. I can, obviously, refresh the dataset through the desktop and upload that to the group files area. The failure sites invalid credentials but they are windows credentials and . . . well I am logged in and working.
And, forgot to add, personal gateway.
OK, I imported and connect to an Excel file on OneDrive for Business and was able to refresh them. Not sure if that exactly mimics your scenario or helps you in any way whatsoever.
I am still gettting a failure. I even replaced the source file on the dataset and it refuses to refresh. It is cascading through other data sets now.
Filed a ticket. Hopeing for help.
Sandy and Greg_Deckler this started after I updated the gateway. Could the gateway be causing this?