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? 

18 REPLIES 18
Highlighted
Memorable Member
Memorable Member

I realize this is an old post - but I didn't see a suggestion that I think is important:

* the 32 bit install of Office is widely recommended and still most common

* the 64 bit install of Power BI is most common

 

I think the idea of altering either to not be the most practical approach to this dilemma.

 

An alternative, if it is at all feasible, is to export the Access tables out to excel.  They can then be brought into Power BI without a problem. 

 

A side benefit to this is that, if one knows the Access data, a simple query can define which data gets exported - and so you can perform the first step of Power BI work as part of this as well by not exporting unneeded fields and also delimiting the range of records.

www.CahabaData.com
Highlighted

Hi,

 

I had the same issue (see error message below)...  so I uninstalled my 32-bit version of office...  and installed 64-bit version...  restarted 2X...  and am still getting the same error...  i.e., unable to Load the Access database tables into Power BI.  Hope to can help.  Thanks.

 

Capture.PNG

Version of Access on my machine:

Capture2.PNG

Highlighted

Did you delete the prior connections and make brand new ones?  Also sanity check your new Access install by opening it and looking at the tables.  You might copy a duplicate of the Access file and change its name slightly....and then attempt to import the tables of this new file.

www.CahabaData.com
Highlighted

Thanks for your reply.  I deleted the prior connections, backed up the database, restored it...  and still get the 64-bit error message.

Highlighted

I guess I didn't ask - - you did do what the message says to do right?  ....downloaded the ODBC connector....

www.CahabaData.com
Highlighted

I'm not sure that I did.  Could you supply best link for that?  Thanks!

Highlighted

actually - please check and confirm your operating system - whether it is 32 or 64

www.CahabaData.com
Highlighted

Capture.PNG

Highlighted

Hi mllopis, 

 

 

I tried your solution, and it worked perfectly. 
But now I have a problem using 32 bits Power BI, is the problem of the memory !

 

I saw on the Internet that 32bits power BI can have this kind of problem, with a massive database, but how to solve it ? 

I can't change my 32bits Access base, and power 32 bits is not powerful enougth, and power 64bits doesn't match with 32bits Access database ! 
How can I solve my problem ? 😮 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors