Forum Discussion
Solved
Scheduled refresh with accdb data source
I installed and set up an on-premises data gateway in order to schedule a refresh of datasets/dashboards. The datasources are a combination of files stored in OneDrive for business and an accdb file....
I have. I was able to get it to work by using a personal gateway - not sure if that helps diagnose why there would be an issue using the on-premesis gateway. Either way I'll just leave it for now.
"Connection to 'XXXXX' failed." (If it's already understood that it's an ODBC connection.