![]() You may need to repeat this process for any other data providers that you need. It’s a good idea to reboot your computer after the install.The files will install successfully in the background while suppressing warnings and errors.Of course you should use the correct path to your file. type c:AccessDatabaseEngine.exe /passive into the command line box and click “OK”.Click the windows button and type run and press enter.Copy the install file to a location on your PC that is easy to access from the command line.Suffice to say however that you should create a restore point and also proceed at your own risk. 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. 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. I strongly suggest you set a restore point before proceeding with this process. If this happens, you can force the install of the 64 bit data providers by following the steps below: Install in Passive ModeĮdit Dec 2017: Warning. 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 all goes well, you are done and you can start using Power BI Desktop. Download the data provider you need (AccessDatabaseEngine.exe 64 bit version in this case here).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. If you have 32 bit Office on your computer, then any data providers you have on your PC will also be 32 bit. When you try to import data using Access, you will most likely get an error message like this.īut don’t panic, just follow the instructions below. Try to Import Data in Power BI DesktopĪfter installing, run Power BI Desktop and try to install some data (say from an Access file like this one). 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.Īfter downloading the file, just go ahead and install it in the normal way. 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. Power Pivot relies on these data providers to connect to the relevant data sources. Install the 64 bit data providers you need (such as the Access Database Engine) so you can import the data you need.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. It is possible to install Power BI Desktop 64 bit on a computer that has 32 bit Office installed. Use caution and I recommend you create a system restore point before proceeding. Also note that this worked for me, but I can’t guarantee it will work for you. 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. Note: You must have 64 bit Windows and Admin Rights to proceed. ![]() If that is not possible, then there is a work around that I explain below. So what to do? Well the best thing is to try to get your system upgraded to 64 bit Office. …but you want to have 64 bit Excel because you want to be a Power Pivot Ninja. So chances are you have 32 bit Office applications installed…
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |