Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
27 | |
21 | |
21 | |
10 |
User | Count |
---|---|
41 | |
36 | |
35 | |
20 | |
14 |