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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Sokon,

Thanks for your sharing the above methods about refreshing Access data source in Power BI Service.

I would like to give some comments on “an Access connection can be configured for the personal Gateway. But what if using a personal gateway is no option for you” in your post. The issue that using personal gateway to connect to the MS Access DB might be related to the 32 bit/64 bit Access database.

Power BI only have 64 bit personal gateway, it is by design to leverage only 64 bits drivers. Referring to the 32 bit MS Access DB, the 64bit access driver is required on the gateway machine .You can download it from here, after that the scheduled refresh could be configured successfully.

In addition, there is an idea about adding Access as data source for on-premises gateway, you can vote it up.

 



Regards,
Lydia