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.