Forum Discussion

nankerp's avatar
nankerp
Helper III
6 years ago

Problem connecting to Microsoft Access when using Dataflow

I get an error when connecting to Access database:

 

An exception occurred: Microsoft Access: Leverandøren Microsoft.ACE.OLEDB.12.0 er ikke registrert på den lokale maskinen. OLEDB-leverandøren av 64-bitersversjonen av Access Database Engine 2010 Access Database Engine kan være påkrevd for å lese Datavarehus.accdb. Gå til følgende nettsted for å laste ned klientprogramvaren: https://go.microsoft.com/fwlink/?LinkID=285987. (Session ID: f9c8d083-a843-4ece-99be-a3576e933670)

 

I have installed a driver when using Power BI Desktop. Why is it not working when I am using Dataflow?

Dataflow
Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    Hi there

    Have you installed the driver on your On-Premise Gateway?
    • nankerp's avatar
      nankerp
      Helper III
      6 years ago

      I have not installed any driver for the Gateway. Where do I install this driver?