cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Power BI does not support 32 bit Access DB

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.

View solution in original post

18 REPLIES 18
Highlighted
Super User IV
Super User IV

Re: Power BI does not support 32 bit Access DB

Are you doing this through the Service or Designer?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper V
Helper V

Re: Power BI does not support 32 bit Access DB

Hi,

 

Are you using 32k/64k version of power BI?

 

I had a problem similar to you (I think) - I have 32K oracle db and when tried to connect to power bi 64K got the same err msg you have/

Try to download the 32k version of power BI hope it will help you like it helped me.

 

 

Highlighted
Regular Visitor

Re: Power BI does not support 32 bit Access DB

@nirrobi thanks for the advice. I think this is prossibly the reason. When I downloaded it, it is defaulted to 64 bit. Do you know if there is any 32 bit available? Cheers.

Highlighted
Regular Visitor

Re: Power BI does not support 32 bit Access DB

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

Highlighted
Helper V
Helper V

Re: Power BI does not support 32 bit Access DB

Yes.

 

 

Highlighted
Microsoft
Microsoft

Re: Power BI does not support 32 bit Access DB

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.

View solution in original post

Highlighted
Frequent Visitor

Re: Power BI does not support 32 bit Access DB

Hi mllopis,

 

Do you have the solution at this time? (not need to change the installation of ACCESS?)

I have the same problem with:

-Oracle: the provider used is deprecated: "systeme.data.oracleclient requires software client Oracle version 8.1.7 or higher"

-Access : The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local computer. The OLEDB provider for the 64-bit version of Access 2010 Access Database Engine database engine is needed to connect and read this type of file

 

@all: if you guys have some document on the prerequired system for data connection to: Access,DB2, ORACLE please send mail at dunganhl@exakis.fr

 

thanks in advance,

Highlighted
Helper I
Helper I

Re: Power BI does not support 32 bit Access DB

For those of us who have a 64bit Windows install and mostly 32bit Drivers, what link do we use to get the 32bit version of PowerBI Desktop?

Highlighted
Super User I
Super User I

Re: Power BI does not support 32 bit Access DB

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

Click download and you can select the x86 version "PBIDesktop.msi"


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors