64 Bit Power BI Desktop with 32 Bit Office? Can do! - Excelerator BI

64 Bit Power BI Desktop with 32 Bit Office? Can do!

As many of you would already know, 32 bit applications do not always play well with their bigger sibling,  64 bit applications.

There are lots of “under the hood” files and applications that are always designed to be either 32 bit or 64 bit – not both.  In the case of Microsoft Office, you must choose either 32 bit or 64 bit across the entire Office Suite.  You can’t for example have 64 bit Excel and 32 bit Outlook, PowerPoint etc (read more about it here).  This is unfortunate because:

  1. The ONLY Office application that can benefit from 64 bit is Excel running Power Pivot.
  2. Many (most) IT departments do not install Office 64 bit (for the same reason I mention above – there are often many conflicts with Addins and applications).

So chances are you have 32 bit Office applications installed…
image

…but you want to have 64 bit Excel because you want to be a Power Pivot Ninja.

So what to do? Well the best thing is to try to get your system upgraded to 64 bit Office.  If that is not possible, then there is a work around that I explain below.

Note: You must have 64 bit Windows and Admin Rights to proceed.  If you don’t have Admin Rights, your IT department may be happy to install 64 bit Power BI Desktop for you as an alternative to Office 64 bit.  Also note that this worked for me, but I can’t guarantee it will work for you.  Use caution and I recommend you create a system restore point before proceeding.

Power BI Online Training

Power BI Desktop 64 Bit

It is possible to install Power BI Desktop 64 bit on a computer that has 32 bit Office installed.  There are a few things you may need to do however to make it work properly (depending on your config), but I explain those things below.  The high level process is:

  1. Install Power BI Desktop 64 bit
  2. Install the 64 bit data providers you need (such as the Access Database Engine) so you can import the data you need. Power Pivot relies on these data providers to connect to the relevant data sources.

Once you have 64 bit Power BI Desktop installed and running, you can then also optionally use Power BI Desktop as a local 64 bit server and direct connect to it from Excel 32 bit by following the instructions and template provided in my blog article here.

Download and Install Power BI Desktop

Installing Power BI Desktop is easy.  You download it from the direct download here or from the Power BI site here,   Which ever place you go, just make sure you download the 64 bit version.

image

After downloading the file, just go ahead and install it in the normal way.

Try to Import Data in Power BI Desktop

After installing, run Power BI Desktop and try to install some data (say from an Access file like this one).  When you try to import data using Access, you will most likely get an error message like this.
image

But don’t panic, just follow the instructions below.

Download the Data Providers you need

If you have 32 bit Office on your computer, then any data providers you have on your PC will also be 32 bit.  These will not work with 64 bit Power BI Desktop and you will need to install the 64 bit versions as well as retaining your 32 bit versions.

Standard Install Process

  1. Download the data provider you need (AccessDatabaseEngine.exe 64 bit version in this case here)image
  2. Try to install the file.  If all goes well, you are done and you can start using Power BI Desktop.

However in some PC configurations, installing 64 bit data providers when there are also 32 bit data providers installed can be harder than you would think, because Microsoft can explicitly try to prevent you from doing this.   If this happens, you can force the install of the 64 bit data providers by following the steps below:

Install in Passive Mode

Edit Dec 2017: Warning.  I strongly suggest you set a restore point before proceeding with this process.  While it seems to work fine for most people, I am aware of increasing numbers of individuals who have had a problem with this approach.  Some have had Office 2010 and it is also possible that there have been changes made to the way the software installs -I can’t be sure.  Suffice to say however that you should create a restore point and also proceed at your own risk.  You have been warned.

  1. Copy the install file to a location on your PC that is easy to access from the command line.  I put mine in C: root folder
  2. Click the windows button and type run and press enter
  3. type c:AccessDatabaseEngine.exe /passive into the command line box and click “OK”.  Of course you should use the correct path to your file.
  4. The files will install successfully in the background while suppressing warnings and errors.
  5. It’s a good idea to reboot your computer after the install.

You may need to repeat this process for any other data providers that you need.  The easiest thing to do is just start using Power BI Desktop until you find you have a problem, then find and install the new 64 bit data providers you need to solve each problem you come across.

Time to Test

Once you have installed the new data providers, it is time to test it out.  Open Power BI Desktop 64 bit and try to connect to data coming from an Access Database.  You can download the Adventure Works Access database here if you need a sample to test.

Use Power BI Desktop 64 bit as a Server on your PC

Take a look at my blog post from a couple of weeks ago.  If you follow then instructions on the other blog post, you will be able to open Power BI Desktop 64 bit, open a large PBIX workbook, and then use Excel to connect directly to Power BI Desktop as a server.  You can also migrate your existing Excel workbooks that are too big for 32 bit Excel to Power BI Desktop (File\Import\Excel Workbook Contents) and then start to use Power BI Desktop as a server (you will have to recreate your visualisations however).

27 thoughts on “64 Bit Power BI Desktop with 32 Bit Office? Can do!”

  1. Hi Matt! Thanks for your incredible resources! I received the error this post is about while using the Calendar table you have in your exercises from ch 8 of Supercharged BI. Is it possible you could simply confirm that I could create my own date table using CALENDER (AUTO)? Or could you comment on what you would use to replicate that table manually? I have limited control over the ability to play around with the bit-level of my work Office products, and am hoping for a non-technical workaround.

  2. My 2 laptops cannot reboot after PowerBI x64bit March 2021 version install.
    It was working fine with previous versions.

    SO be careful 😉

  3. Hallo Matt,
    Actually I am trying to get the data from access into my Power BI application. Both Power BI and Access which I am using are 32 bit. But the error shows that unable to connect because they need some data providers ‘Microsoft.ACE.OLEDB.12.0’ provider . Can you please help me in this?

    Thanks & Regards,
    Utsav

  4. September 21, 2019
    I got the “Unable to Connect” dialog when I first tried to connect to the AdventureWorks database. I’m running 64-bit Windows 10 Home and 64-bit Office 365 Pro Plus, so I was puzzled as to why I got the dialog. I went ahead, created the restore point and downloaded/installed the Microsoft Access database engine 2010, which turns out to be version 14.07015.1000. The Access file loaded into Power BI just fine. I don’t know why, but it doesn’t matter.
    Thanks, Matt.

  5. Thank you so much! This is a gem of an article. Saved a lot of hairs on my head.
    This worked for my PowerBi (64 bit) in my 32-bit Office in my 64-bit system.

  6. I am running O365 64-bit which includes Access. I have installed Power BI Desktop- 64 bit. I am receiving the error above when I try to connect. System will not allow me to install the redistributable as recommended by Microsoft since I am on later versions. Please advise.

  7. I’ve had problems with this. Since I tried the passive install, when I try to use Excel or Word a Microsoft Configuration runs before the application opens. Microsoft Project (2010) tries to re-install and Access (2007) tries to repair – both processes fail so I cannot run these applications now. Any suggestions as to what I’ve done wrong

    1. Hi Jerry, that doesn’t sound good. I wonder if it is because of the older versions of the software you are using. I would suggest you return to the previous system restore point I guess.

      1. William Hipple

        Oh! It’s just me and my laptop and desktop. No IT to get the permission. Looks like this is passive

  8. Thank you very much Matt. I was struggling with Office 365 and Access 2010 and this worked great (the pasive installation did the trick)

  9. Thank you so much for this guidance Matt.
    I have a good few models built in Power Pivot against Access (32bit). Now I can move to delivering a whole suite of reporting to Power BI using my current models !!

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top