Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have an Access Database in a sharepoint folder. I get data from this database in a Power BI Report and in the desktop the report refresh normally. But when I tried to refresh it on the service I got an error
I have 64bit office.
Can you please assist? Do I have to install this and where in order to have the schedule refresh run smoothly? Do I have to setup a Data Gateway eventhough my Access Database is on a Sharepoint Folder?
Thank you in advance,
Eleftheria
Solved! Go to Solution.
Yes, you need gateway as access database is a legacey source
You need to install Access Database Engine 2010 on gateway server (not on local system).
As you are using access database (legacy source) you will need a gateway to refresh from Power BI
Configure a gateway and install The 64-bit version of the Access Database Engine 2010 https://www.microsoft.com/en-us/download/details.aspx?id=13255 on Gateway server
then create a data source for your access database file (even it is on SharePoint)
@arvindsingh802 I need Data Gateway even though my Access Database is on Sharepoint? My office are 64bit. If I have to install the Access Database Engine where should I install it in order to run scheduled refreshes?
Yes, you need gateway as access database is a legacey source
You need to install Access Database Engine 2010 on gateway server (not on local system).
You Don't need a Gateway because as you said the Access file you are trying to pull data from is on sharepoint.
The problem might be the data souce settings. Have you checked it?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.