Forum Discussion
Using MS Access as a data source with On-Premises Data Gateway
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.
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!
Sokon, you are right! I have the 64 bit "On-Premises Data Gateways" installed.
I tried your approach and I set up an file DSN for an MS Accces DB.But what is exactly the string I have to use, (Gateway & Desktop) when I try to connect through DSN file?
Thank you!Using a file DSN is not my approach and it won't work. :smileyhappy: Use a DSN-less connection. Example for that is in the main post.
