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:
- The ONLY Office application that can benefit from 64 bit is Excel running Power Pivot.
- 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…
…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 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:
- Install Power BI Desktop 64 bit
- 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.
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.
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
- Download the data provider you need (AccessDatabaseEngine.exe 64 bit version in this case here)
- 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.
- 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
- Click the windows button and type run and press enter
- type c:AccessDatabaseEngine.exe /passive into the command line box and click “OK”. Of course you should use the correct path to your file.
- The files will install successfully in the background while suppressing warnings and errors.
- 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).
Hello, just wanted to tell you, I liked this post. It was practical.
Keep on posting!
Thank you for sharing your info. I really
appreciate your efforts and I am waiting for your further write ups
thank you once again.
Als u dit bericht tegenkomt waarin u probeert een geregistreerd rijbewijs te kopen zonder de examens, dan staan wij voor u klaar. Klik eenvoudig op de onderstaande link om met een agent te praten. de agent zal u begeleiden bij het verkrijgen van het rijbewijs b
https://mijnrijbewijscbr.com/
Als u dit bericht tegenkomt waarin u probeert een geregistreerd rijbewijs te kopen zonder de examens, dan staan wij voor u klaar. Klik eenvoudig op de onderstaande link om met een agent te praten. de agent zal u begeleiden bij het verkrijgen van het rijbewijs
https://kopakorkort-se.com/
Als u dit bericht tegenkomt waarin u probeert een geregistreerd rijbewijs te kopen zonder de examens, dan staan wij voor u klaar. Klik eenvoudig op de onderstaande link om met een agent te praten. de agent zal u begeleiden bij het verkrijgen van het rijbewijs
https://echtrijbewijskopen.com/
Se você se deparar com esta mensagem buscando comprar uma carteira de motorista registrada sem os exames então estamos aqui para ajudá-lo, basta clicar no link abaixo para falar com um agente. o agente irá orientá-lo sobre como obter a carteira de motorista
https://imt-cartadeconducao.com/
This page really has all of the info I needed concerning this subject and didn’t know who
to ask.
πραγματική άδεια οδήγησης και εγγραφείτε στον ιστότοπό μας χωρίς να χρειάζεται να λάβετε καμία εξέταση ή να περάσετε σε πρακτική δοκιμασία. το μόνο που χρειαζόμαστε είναι τα στοιχεία σας και θα καταγραφούν στο σύστημα εντός των επόμενων οκτώ ημερών. Η άδεια οδήγησης πρέπει να ακολουθεί την ίδια διαδικασία εγγραφής με την άδεια που εκδίδεται στις σχολές οδηγών,
https://agoraadeiasodigisis.com/
Kjøp ekte og registrert førerkort fra nettsiden vår uten å skrive eksamen eller ta praksisprøven. alt vi trenger er opplysningene dine, og de vil bli registrert i systemet innen de neste åtte dagene. kjøp førerkort belgia, kjøp førerkort belgia, kjøp førerkort i nederland, førerkort b belgia, kjøp førerkort med registrering.
https://kjop-forerkort.com/
Kupite legal vozačku dozvolu i registrujte se na našoj veb stranici bez polaganja bilo kakvog ispita ili polaganja praktičnog testa. sve što nam je potrebno su vaši podaci i oni će biti zabeleženi u sistemu u narednih osam dana. Vozačka dozvola mora proći isti postupak registracije kao i dozvola izdata u auto-školama
https://kupitivozackudozvola.com/
Cumpărați un permis de conducere în Franța fără un test. Oferim absolut toate clasele de permis de conducere din Romania
https://cumparpermisconducere.com/
pravu vozačku dozvolu i registrujte se na našoj veb stranici bez polaganja bilo kakvog ispita ili polaganja praktičnog testa. sve što nam je potrebno su vaši podaci i oni će biti zabeleženi u sistemu u narednih osam dana. Vozačka dozvola mora proći isti postupak registracije kao i dozvola izdata u auto-školama
https://kupitivozackadozvola.com/
pravu vozačku dozvolu i registrujte se na našoj veb stranici bez polaganja bilo kakvog ispita ili polaganja praktičnog testa. sve što nam je potrebno su vaši podaci i oni će biti zabeleženi u sistemu u narednih osam dana. Vozačka dozvola mora proći isti postupak registracije kao i dozvola izdata u auto-školama
https://kupitevozackudozvolu.com/
Kopa ekte og registrert førerkort fra nettsiden vår uten å skrive eksamen eller ta praksisprøven. alt vi trenger er opplysningene dine, og de vil bli registrert i systemet innen de neste åtte dagene. kjøp førerkort belgia, kjøp førerkort belgia, kjøp førerkort i nederland, førerkort b belgia, kjøp førerkort med registrering.
https://kopaktakorkort.com/
carta de condução real e registe-se no nosso site sem fazer qualquer exame ou teste prático. apenas necessitamos dos seus dados e ficarão registados no sistema nos próximos oito dias. A carta de condução deve passar pelo mesmo processo de registo que uma carta emitida por uma escola de condução
https://cartaconducaolegal.com/
Prawo jazdy i zarejestruj się na naszej stronie internetowej bez konieczności zdawania egzaminu ani testu praktycznego. Potrzebujemy tylko Twoich danych, które zostaną zarejestrowane w systemie w ciągu najbliższych ośmiu dni. Prawo jazdy musi przejść tę samą procedurę rejestracji, co prawo jazdy wydane w szkołach nauki jazdy.
https://kupprawojazdy.com/
Way cool! Some very valid points! I appreciate you writing this post and
the rest of the site is also very good.
Pretty great post. I just stumbled upon your
blog and wished to mention that I have really loved browsing your weblog posts.
In any case I’ll be subscribing to your rss feed and I hope you write again soon!
sportbootführerschein binnen und see, sportbootführerschein binnen prüfungsfragen, sportbootführerschein binnen kosten, sportbootführerschein binnen online, sporthochseeschifferschein kaufen, sportbootführerschein binnen berlin, sportbootführerschein binnen segel, sportbootführerschein kaufen, sportseeschifferschein kaufen erfahrungen, sportküstenschifferschein kaufen schwarz, sportbootführerschein see kaufen, sportbootführerschein binnen kaufen, sportbootführerschein see kaufen ohne prüfung, bootsführerschein kaufen, bootsführerschein kaufen polen, bootsführerschein kaufen erfahrungen, bootsführerschein online kaufen, bootsführerschein tschechien kaufen, SSS kaufen, SKS kaufen, SHS kaufen, führerschein kaufen,sportbootführerschein see, österreichischen führerschein kaufen legal, kaufen swiss registrierte führerschein, registrierten führerschein kaufen berlin, echten führerschein kaufen Köln, legal führerschein kaufen, echten deutschen führerschein kaufen, deutschen registrierten führerschein kaufen, osterreichischen-fuhrerschein-kaufen zürich, deutschen registrierten führerschein kaufen…6tf4
gdzie mozna kupic prawo jazdy z wpisem do rejestru, kupić prawo jazdy, legalne prawo jazdy do kupienia, kupię prawo jazdy, jak załatwić prawo jazdy, bez egzaminu, jak kupić prawo jazdy, czy można kupić prawo jazdy, legalne prawo jazdy do kupienia 2025, pomogę zdać egzamin na prawo jazdy, prawo jazdy bez egzaminu, gdzie kupić prawo jazdy bez egzaminu, gdzie kupić prawo jazdy na lewo, jak kupić prawo jazdy w niemczech, gdzie kupic prawo jazdy legalnie, kupić prawo jazdy b, pomogę zdać egzamin na prawo jazdy, gdzie można kupić prawo jazdy z wpisem do rejestru forum, prawo jazdy płatne przy odbiorze, prawo jazdy czechy kupno, w jakim kraju można kupić prawo jazdy, pomogę załatwić prawo jazdy w uk, sprzedam prawo jazdy z wpisem bez zaliczek, jak kupić prawo jazdy w uk, ile kosztuje prawo jazdy na lewo?, iuhki9
Thankfulness to my father who told me concerning this webpage, this webpage is really awesome.
Unquestionably believe that which you said. Your favorite justification seemed
to be on the internet the simplest factor to
be mindful of. I say to you, I certainly get irked while folks consider
issues that they just do not recognise about.
You controlled to hit the nail upon the highest and defined out the
whole thing with no need side effect , people could take a signal.
Will probably be back to get more. Thank you
I would like to show my appreciation for your generosity supporting folks that absolutely need guidance on this content. Your personal dedication to getting the solution all through turned out to be definitely helpful and has always permitted many people much like me to attain their ambitions. Your own informative guidelines denotes this much a person like me and especially to my mates. Thanks a ton; from all of us.
Hi there, just became aware of your blog through Google, and found that it’s really informative. I am going to watch out for brussels. I’ll be grateful if you continue this in future. Numerous people will be benefited from your writing. Cheers!
It is in point of fact a great and useful piece of information. I?¦m happy that you shared this useful information with us. Please stay us informed like this. Thank you for sharing.
I blog quite often and I truly appreciate your content.
This article has truly peaked my interest. I’m going to bookmark your site and keep checking for new information about once per week.
I opted in for your RSS feed too.
Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You obviously know what youre talking about, why waste your intelligence on just posting videos to your weblog when you could be giving us something enlightening to read?
I every time used to study article in news papers
but now as I am a user of web so from now I am using net for articles or reviews, thanks
to web.
Actually no matter if someone doesn’t know afterward its up to other users that they will help, so here it happens.
Really when someone doesn’t understand afterward its up to other people that they will assist, so here it takes place.
This excellent blog website is unusual. Content like this are most
often not considered, if real truth be told.
In many instances the best of the World-wide-web
isn’t actually the most broadly advertised posts,
though rather all things else, the pushed aside masses with weblogs that are ultimately way superior as opposed to
the ones of essential widley known folks. Now this is such a blog page.
I will present tips, quite possibly in cases where we’re not prompted to do
this. Very first is, continue to keep producing. Secondary
is, maintain writing frequently. Lastly is, utilize your own personal blog page to improve your own personal
approach. I am not really a article author per se; I am in fact
a Postpartum Massage Therapist. I apply Postnatal Massage Therapy, being
able to help females to heal just after having a child. It’s fulfilling work.
That is precisely what I commit the majority of my work time doing, however I have as well
fell in love with producing from the point in time
I was a teen. I am a well-read human being and each calendar year I go through a stack far taller in comparison with myself personally.
rofl In the following calendar year, could be I will get determined related to operating a blog.
The matter is, it cannot basically an outline; the activity of writing and establishing regularly makes a blogging site get bigger in time.
I like this web site so much, saved to my bookmarks. “Nostalgia isn’t what it used to be.” by Peter De Vries.
I do accept as true with all the ideas you’ve introduced for your post.
They’re really convincing and will definitely work.
Still, the posts are very brief for novices. May just you please lengthen them a little from subsequent time?
Thanks for the post.
Hello there, just became aware of your blog through Google, and
found that it’s really informative. I’m going to watch out for brussels.
I’ll appreciate if you continue this in future. Numerous people will be benefited from
your writing. Cheers!
Great post. I’m experiencing many of these issues as well..
Great blog here! Also your site loads up very fast! What
web host are you using? Can I get your affiliate link to your host?
I wish my website loaded up as fast as yours lol
Hi there! Someone in my Facebook group shared this site with
us so I came to give it a look. I’m definitely enjoying the information. I’m book-marking and will be tweeting this to my followers!
Excellent blog and fantastic design.
Hey there! I just wanted to ask if you ever have any problems with hackers?
My last blog (wordpress) was hacked and I ended up losing several weeks of hard work
due to no back up. Do you have any methods to protect
against hackers?
I have been exploring for a little bit for any high-quality articles or weblog posts on this sort of area .
Exploring in Yahoo I eventually stumbled upon this website.
Studying this info So i am glad to convey that I have
a very excellent uncanny feeling I discovered just what
I needed. I such a lot without a doubt will make sure to do
not omit this website and provides it a look on a continuing basis.
May I just say what a relief to uncover somebody
who genuinely understands what they are discussing on the web.
You definitely know how to bring a problem to light and make it important.
More people really need to look at this and understand this
side of your story. I was surprised that you are not more popular because you definitely possess the gift.
With havin so much content do you ever run into any problems of plagorism or copyright violation? My site
has a lot of exclusive content I’ve either written myself or
outsourced but it looks like a lot of it is popping it up all over the internet without my agreement.
Do you know any ways to help reduce content from
being ripped off? I’d definitely appreciate it.
I was able to find good information from your content.
I often encounter content such as this at some of the most
unlikely times. Such as right now, I was seeking out a specific
thing on an absolutely different concern and I uncovered this article instead.
I usually spend time searching the net for articles or blog posts, but
yet usually I love to be out in the open, experiencing the outdoors
in the neighborhood woodlands. You’ll find nothing is similar to fresh air to help you really feel rejuvenated.
This is whenever i am not doing work as an in-home massage therapist.
That consumes almost all my time.
Appreciating the persistence you put into your site and in depth information you present.
It’s awesome to come across a blog every once in a while that isn’t the same
out of date rehashed material. Fantastic read! I’ve saved your site and I’m adding your RSS feeds to my Google account.
Hmm is anyone else experiencing problems with the
images on this blog loading? I’m trying to figure out if its a problem
on my end or if it’s the blog. Any suggestions would be greatly appreciated.
First, thank you for the information, and your perception. I can value this
weblog and most importantly suggestions. At this time, Personally i think I fritter away much too enough
time via the internet, browsing rubbish, actually. This is a refreshing change from that experience.
Yet, I believe examining other people’s ideas is
a very important investment of at any rate some of my weekly measure of amount of time in my schedule.
It’s the same as sifting throughout the chaff to get the wheat.
Or else, whatever illustration functions for you.
Still, near the laptop is most likely as bad
for you as smoking cigarettes and fried potato chips.
The following time I read a blog, I hope that it doesnt disappoint me as much as this one. I imply, I do know it was my choice to read, but I really thought youd have something fascinating to say. All I hear is a bunch of whining about something that you might fix if you happen to werent too busy searching for attention.
Very interesting subject, thank you for posting.
F*ckin’ awesome issues here. I am very happy to peer your article. Thank you so much and i’m looking forward to contact you. Will you please drop me a e-mail?
Good V I should definitely pronounce, impressed with your website. I had no trouble navigating through all tabs and related information ended up being truly easy to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your customer to communicate. Nice task..
Only wanna comment on few general things, The website design is perfect, the content is real great. “The stars are constantly shining, but often we do not see them until the dark hours.” by Earl Riney.
Great V I should definitely pronounce, impressed with your site. I had no trouble navigating through all tabs as well as related info ended up being truly simple to do to access. I recently found what I hoped for before you know it at all. Quite unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your customer to communicate. Nice task..
Very fantastic information can be found on web blog.
Would you be keen on exchanging hyperlinks?
Este site é realmente fabuloso. Sempre que consigo acessar eu encontro coisas incríveis Você também pode acessar o nosso site e descobrir detalhes! informaçõesexclusivas. Venha descobrir mais agora! 🙂
I have not checked in here for a while as I thought it was getting boring, but the last several posts are great quality so I guess I’ll add you back to my everyday bloglist. You deserve it my friend 🙂
Some truly superb articles on this web site, appreciate it for contribution.
Great tremendous things here. I am very happy to look your post. Thanks a lot and i’m taking a look ahead to touch you. Will you please drop me a mail?
Thanks for any other informative blog. The place else may I get that kind of info written in such an ideal approach? I have a undertaking that I am just now operating on, and I have been at the look out for such info.
Would you be all for exchanging hyperlinks?
I like this post, enjoyed this one regards for posting.
Thank you for your sharing. I am worried that I lack creative ideas. It is your article that makes me full of hope. Thank you. But, I have a question, can you help me?
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.
Which book are you using? The download file has an excel version of the sample data. If you use that, it shouldn’t be an issue. You can find the download here https://exceleratorbi.com.au/supercharge-power-bi-book/
My 2 laptops cannot reboot after PowerBI x64bit March 2021 version install.
It was working fine with previous versions.
SO be careful 😉
What does “cannot reboot” mean? I’ve never heard of this before. Every pc can be rebooted, normally by holding the power button (if it is frozen)
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
It is the same instructions as provided in this blog, just install the 32bit version instead.
Thanks Matt! Worked well for my home sandpit machine 🙂
Great instructions and worked perfectly!
Thanks Matt.
This worked perfectly for me! Thanks!
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.
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.
Try using: AccessDatabaseEngine.exe /quiet
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.
I see no reason why this wont work. I suggest you try Microsoft support for this
thank you.
This is the offical support page from Microsoft
https://docs.microsoft.com/en-us/power-bi/desktop-access-database-errors
Thanks Matt.
Using the “/passive” makes the file unrecognizable
sorry this didn’t work for you Steve. It has certainly worked for many others in the past. It is possible that something has changed since I wrote this of course.
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
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.
Oh! It’s just me and my laptop and desktop. No IT to get the permission. Looks like this is passive
Thank you very much Matt. I was struggling with Office 365 and Access 2010 and this worked great (the pasive installation did the trick)
Thank you for writing this. It worked for me.
Thank You very much… This was a great article and saved lot of time
Does the 32bit engine still work after this step, eg can I still connect to Access from Excel?
Yes, the 32 bit connectors still work
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 !!