Error with Access whil refreshing dataset

[Arkhos94]

One of my power BI report's dataset includes an Acess database (on a sharepoint) named "Suivi réclamations"

In Power BI Destkop, I don't have any issue refreshing the data

But when I refresh it directly in the power BI workspace on https://app.powerbi.com/, the update fails and I get the following error message :

Erreur de source de données:

DataSource.NotFound: <ccon>Microsoft Access: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the 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.. </ccon>. The exception was raised by the IDbCommand interface. Table: Suivi réclamations.

Can someone help me understand this message ?

[ibarrau · Accepted solution]

Hi. In order to connect with Access data at PowerBi Service, you need to use an OnPremise Data Gateway. You might wonder why if it's at sharepoint. That's because the power query connector for accesss need a driver to read it that will only run at a windows. The thing with Access it's that it's an old way of keeping data. 

You can read about this here: https://learn.microsoft.com/en-us/power-query/connectors/access-database

This is the driver you need: https://www.microsoft.com/en-us/download/details.aspx?id=54920

I hope that make sense

[Arkhos94]

I'm not sure I understand everything in your link but it seems to be the solution to my problem => thanks

I will work on it with my IT department