Forum Discussion

Sokon's avatar
Sokon
Advocate V
8 years ago

Using MS Access as a data source with On-Premises Data Gateway

23.11.2018: Another update: The order of the installations is important. 22.11.2018: I updated this article. Let me know if it works for you!   When publishing a report that uses an on-Premises MS...
Tips and Tricks
BWL's avatar
BWL
Helper II
8 years ago

I just checked and I have the drivers installed, but it still doesn't work. 

 

Just to be sure, I have installed now:

  • PowerBI Desktop 32 bit
  • MS Acces 32 bit
  • Enterprise Gateway 64 bit
  • Microsoft Acces Database Engine 2010 32 bit   on the gateway server

You have exactly the same set up right?

Sokon's avatar
Sokon
Advocate V
8 years ago

I think so, yes!

  • BWL's avatar
    BWL
    Helper II
    8 years ago

    Sokon,

    Thank you for your reply.
    I have exactly the same set up, but I don't get it work.
    Still can't connect because of the "wrong driver specified". 

    I think the gateway 64 bit just can't connect with the 32 bit driver. 


    Hope i'll find another solution someday. :)

  • Sokon's avatar
    Sokon
    Advocate V
    7 years ago

    BWL: I had to move the Access connection and therefore had to redo everything I wrote on another machine. I updated the main post accordingly and you might want to try again. I added information about what I installed and fixed a wrong information in the permission part.