Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Arkhos94
Helper IV
Helper IV

Error with Access whil refreshing dataset

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 ?

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

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


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

2 REPLIES 2
ibarrau
Super User
Super User

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


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.