Atlanta Business Intelligence Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Error in connecting to Access DB

    Posted Apr 28, 2018 03:44 PM

    I am fairly new to the Power BI and have been trying to connect to Access DB and getting below Error.
    Can anyone help to resolve it.

    Amanpreet Singh


  • 2.  RE: Error in connecting to Access DB

    Posted Apr 28, 2018 03:46 PM
    Hi Amany;

    Have you gone to the URL in the error message? It looks like a driver issue to me.


    director - product marketing

    tel 443-656-3313
    mobile 443-472-7226
    twitter @mikehillyer

  • 3.  RE: Error in connecting to Access DB

    Posted Apr 30, 2018 08:07 AM
    Because the provider hasn't been registered on the machine on which the application is running. The ACE provider is not installed on Windows operating systems by default. You have to install it. The ACE provider is available in two forms:
    Microsoft Office Access database engine 2007 and the Microsoft Access Database Engine 2010 Redistributable. The 2007 version is only available as a 32-bit component whereas the 2010 version offers both 32 and 64-bit options. You need to be careful which option you choose, because a wrong choice here is the most frequent cause for the error message.

    Hope that helps

    King Strategy Solutions
    Kingstrategysolutions remove preview
    King Strategy Solutions
    Aligning your Business Strategy with Office 365 Technology We provide and implement strategic solutions using the Microsoft Office 365 to maximize your return on investment. We analyze and optimize business processes to reduce completion time. We challenge the status quo by not accepting "We've always done it this way".
    View this on Kingstrategysolutions >

    Jay King
    King Strategy Solutions