Refresh access DB hosted on sharepoint power Bi service

Question

Hi,I have created my Acess database, that is hosted on&nbsp; a sharepoint folder (SharePoint.Files connector).On power BI desktop the refresh works fine.But on Power BI service I got this error&nbsp;"Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.&nbsp;The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987."I carefully checked the processor architecture of ech component (Microsoft power Bi desktop is on 64 bit, the&nbsp;Access Database Engine 2010 is on 64 bit also, and the Microsoft Access Database is also on 64bit).Everyting should be fine now but I got the same error.&nbsp;What is wrong now ???Your support will be greatly appreciated.Thanks&nbsp;

augustindelaf · Answer

Greg_Deckler&nbsp;, many thanks for your support in advance.Best regards,Augustin

augustindelaf · Answer

Greg_Deckler&nbsp;,thanks again for the answer.I think your are right.&nbsp;But it is not very clear for me (us), as we are not very familiar with Access, SharePoint, and gateways.Our traditional method is to connect Excel Files stored in a SharePoint to Power BI, and it works both on PBI Desktop and PBI Service, but too slow. (on demand refresh can last up to 10 minutes).Then we tried Incremental Refresh (now free for PBI Pro) but too hard to implement. (There is an ongoing thread by me on the community about this issue).&nbsp;Then, we need to know how to do :-How can we make Power BI connexion to MS Access work, both&nbsp;on PBI Desktop and PBI Service ?(currently works on PBI Desktop, not on the service).&nbsp;"Thus, you could get around that by using a local gateway with the Access database drivers installed."Do we have to install a gateway in the sharepoint, then ? How, where ?As a reminder :&nbsp;Power BI is connected to the SharePoint Folder (SharePoint.Files method), where the Access DB is stored, and it correctly reads and refreshes the data from the Access DB (when we are in PBI Desktop). We need to make it work in PBI Service.&nbsp;Many thanks in advance for telling us what to do.BR,Augustin

greg_deckler · Answer

Again&nbsp;augustindelaf&nbsp;I am fairly confident that Microsoft did not implement Access drivers on their cloud based service. You can argue with me about not needing a gateway because the file is in SharePoint but I think that the results speak for themselves. 🙂
&nbsp;
I am betting that Microsoft never intended for the cloud gateway to retrieve Access databases from SharePoint. Excel, yes, CSV, sure but not Access.&nbsp;Use your own data gateway.&nbsp;
&nbsp;
If you have a Pro account, open a ticket with Microsoft and ask them.
You could check the Issues forum here:https://community.powerbi.com/t5/Issues/idb-p/IssuesAnd if it is not there, then you could post it.If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

greg_deckler · Answer

Is Access installed on your gateway computer?

augustindelaf · Answer

Why do we need to install gateway on desktop ? my Access DB is hosted on sharepoint.Thanks,

Forum Discussion

Refresh access DB hosted on sharepoint power Bi service

10 Replies

Related content

Incremental Refresh on Dataflow sourced from SharePoint

Fabric SharePoint Shortcut - Service Principle

Fabric Sharepoint Shortcut not Refreshing

Power BI Service refresh error with Web.Contents and SharePoint

Power BI Service Refresh Failing for Dynamic SharePoint Web.Contents (Works in Desktop)