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

Dear Sokon and Anonymous

 

First of all, thank you for your post! 

 

I have a PowerBI model which combines data from an Oracle and different MS Access dbs.
Unfortunately we are stuck with the 32 bit version and we can’t change it.


My goal is to set up a scheduled refresh with the enterprise gateway and the different 32 bit MS Access dbs.

 

At the moment I have installed:

  • PowerBI Desktop 32 bit
  • Enterprise Gateway 32 bit and configured with the Oracle DB

Is it even possible to use the same approach as you did and set up a scheduled refresh via ODBC?

Thanks in advance. 

 

Sokon's avatar
Sokon
Advocate V
8 years ago

Anonymous's comment is not about the enterprise gateway but about the personal gateway. In that case, people install their own gateway and are likely to run into 32bit/64bit issues depending on various circumstances, one of them being the version of the installed Office.

 

As far as i know, there's only one version of the "On-Premises Data Gateways" that should be 64bit.

 

In your case, i think you should be fine. In my scenario we use 32bit as well.

 

It should also be possible to mix 64bit und 32bit db drivers on a gateway. You just can't run both the Access 32bit an 64bit driver on the same machine - or at least not without additional tricks.

 

Hope that helps!