Forum Discussion

Mo-PHAT's avatar
Mo-PHAT
Icon for Helper I rankHelper I
7 years ago
Solved

Online refreshing with Access database on Gateway

I have an access database successfully installed to the gateway but when I try to refresh my dataset I get this error:

 

Something went wrong
Unable to connect to the data source undefined.
Please try again later or contact support. If you contact support, please provide these details.
Underlying error code-2147467259 Table: People.
Underlying error messageUnspecified error
DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
Microsoft.Data.Mashup.ValueError.ReasonDataFormat.Error
 
Sometimes it refers to other tables in the access database too.  I have not done any data format changes to those 2 tables and most are just text or dates.
 
Any suggestions?
 
Thanks
Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Mo-PHAT ,

     

    As the online document, Access database is not supported for on-prem gateway.  You can certainly connect to a file using the personal gateway.

     

    Regards,

    Frank

    • v-melmuz's avatar
      v-melmuz
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      v-frfei-msftI am having the same issue but random times it will refresh and I'd say about 3 weeks ago I had no issues refreshing it. If it's not supported why would it work randomly? Thank you