Reply
Frequent Visitor
Posts: 3
Registered: ‎03-19-2017
Accepted Solution

Error in Lab 1 - Unable to connect.

In order to complete the first lab, we have to connect PowerBI to the database file 'PowerBi.accdb'.  Here is the error message.  This is the same error message from both the available download on edX and on github.com.

 

Unable to connect

 

We encountered an error while trying to connect.

 

Details: "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 2010 Access Database Engine OLEDB provider may be required to read 'PowerBI.accdb'.  To download the client software, visit the following site:  https//go.microsoft.com/fwlink?LinkID=285987


Accepted Solutions
Frequent Visitor
Posts: 3
Registered: ‎03-19-2017

Re: Error in Lab 1 - Unable to connect.

Okay, it appears as if the version of PowerBI desktop does not match the Office version I have.  One is 32 bit and the other is 64 bit. Unless they are both the same, it won't work.  I have to download the correct Power BI version. 

View solution in original post


All Replies
Member
Posts: 138
Registered: ‎03-10-2016

Re: Error in Lab 1 - Unable to connect.

You need to download Access Database Engine from the link https//go.microsoft.com/fwlink?LinkID=285987

Frequent Visitor
Posts: 3
Registered: ‎03-19-2017

Re: Error in Lab 1 - Unable to connect.

Okay, it appears as if the version of PowerBI desktop does not match the Office version I have.  One is 32 bit and the other is 64 bit. Unless they are both the same, it won't work.  I have to download the correct Power BI version. 

Highlighted
Member
Posts: 138
Registered: ‎03-10-2016

Re: Error in Lab 1 - Unable to connect.

Great