Forum Discussion
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.
v-yuta-msft
Community Support
Community SupportAnonymous ,
It seems like an issue of ODBC. Have you installed the same version of power bi and ACCDB(64-bit or 32-bit)?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.