Forum Discussion

DashboardABC's avatar
DashboardABC
Regular Visitor
10 years ago
Solved

Power BI does not support 32 bit Access DB

Tried to import some Access DataBase queries into Power BI dataset but got reminded it does not support 32 bit Access. Is this an attention to work this way or it is a bug can be fixed? 
General Comment
Need Help
  • mllopis's avatar
    mllopis
    10 years ago

    Hi all,

     

    Both 32-bit and 64-bit are supported when it comes to importing Access files. The only requirement is to have the ACE OLEDB provider installed on your machine, in a bit-ness that matches the one of your Power BI Desktop installation.

     

    If you have Office installed in your machine, the ACE OLEDB provider comes with it and it matches the bitness of Office. This might be an issue if you're running 32-bit Office in a 64-bit environment as there is no way to overwrite the version of the ACE OLEDB provider and, by default, Power BI Desktop will be installed in 64-bit.

     

    Your options are either to install 64-bit Office (not likely, I assume, due to other dependencies), or to install Power BI Desktop 32-bit. You can pick the exact bitness and language that you want from our Advanced Download page:

    https://www.microsoft.com/en-us/download/details.aspx?id=45331

     

    We're currently looking at other solutions that don't require a change to your installation, but don't have a timeline to share at this stage.

     

    Hope this helps.

    M.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

Are you doing this through the Service or Designer?

  • DashboardABC's avatar
    DashboardABC
    Regular Visitor
    10 years ago

    I am talking about the Power BI desktop. So i assume it is the designer in your word?

    • nirrobi's avatar
      nirrobi
      Helper V
      10 years ago

      Yes.

       

       

      • mllopis's avatar
        mllopis
        Community Admin
        10 years ago

        Hi all,

         

        Both 32-bit and 64-bit are supported when it comes to importing Access files. The only requirement is to have the ACE OLEDB provider installed on your machine, in a bit-ness that matches the one of your Power BI Desktop installation.

         

        If you have Office installed in your machine, the ACE OLEDB provider comes with it and it matches the bitness of Office. This might be an issue if you're running 32-bit Office in a 64-bit environment as there is no way to overwrite the version of the ACE OLEDB provider and, by default, Power BI Desktop will be installed in 64-bit.

         

        Your options are either to install 64-bit Office (not likely, I assume, due to other dependencies), or to install Power BI Desktop 32-bit. You can pick the exact bitness and language that you want from our Advanced Download page:

        https://www.microsoft.com/en-us/download/details.aspx?id=45331

         

        We're currently looking at other solutions that don't require a change to your installation, but don't have a timeline to share at this stage.

         

        Hope this helps.

        M.