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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors