Forum Discussion
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.
Community AdminHi 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.
Helper IHi 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 ? :o