Forum Discussion

mterry's avatar
mterry
Helper V
7 years ago
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....
Need Help
  • mterry's avatar
    mterry
    7 years ago

    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's avatar
v-yuta-msft
Community Support
7 years ago

mterry ,

 

For troubleshooting, you can try installing the lastest version of on-premises data gateway and configure the MS Access data source in power bi service(manage gateway) then check if this issue persists.

 

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.

  • mterry's avatar
    mterry
    Helper V
    7 years ago

    I have actually already taken those steps and I am still having an issue. The Data Source settings say the connection is successful and the gateway cluster settings says 'Online: You Are Good to Go'

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      mterry ,

       

      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.

      • mterry's avatar
        mterry
        Helper V
        7 years ago

        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.