Forum Discussion
Helper IVError 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 ?
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
2 Replies
- ibarrau
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
Arkhos94I'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