cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Analyze in Excel - 64 bit Windows and 32 bit Excel Issue

I have a 64 bit Windows 10 system. I have 32 bit office including Excel. I am trying to use the Analyze in Excel feature. I have downloaded and installed the libraries, but I noticed that it defaulted to the 64 bit version.

 

Any time I try to open an .odc file, I get the following error: 

 

"Initialization of the data source failed. Check the database server or contact your database administator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database."

 

Could you provide a link where I could download the 32 bit version to see if that resolves my issue?

4 REPLIES 4
Highlighted
Frequent Visitor

Re: Analyze in Excel - 64 bit Windows and 32 bit Excel Issue

Hi @Stuart_S 

 

Accoring to this post here: 

https://community.powerbi.com/t5/Power-Query/32-bit-installer-for-amp-quot-Analyze-in-Excel-amp-quot...

 

you can get the 32bit version within this pack here:

https://www.microsoft.com/en-us/download/details.aspx?id=52676 

 

 

I am sure if this will solve your problem tho. 

Let me know if it works. If not, we can take other actions. 

 

kr

 

Highlighted
Community Support
Community Support

Re: Analyze in Excel - 64 bit Windows and 32 bit Excel Issue

Hi @Stuart_S ,

 

Based on this documentsThe Excel libraries need to match your version of Windows in terms of its bit-level. If you have 64-bit Windows installed, you need to install the 64-bit OLE DB provider.

 

You can try to uninstall the add on and then reinstall it, please refer to this post which has same error as yours.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Analyze in Excel - 64 bit Windows and 32 bit Excel Issue

Ok that makes sense on the 64 bit answer. I tried uninstalling "Microsoft Analysis Services OLE DB Provider" from my pc. I then reinstalled it using the down arrow "download" button from my PowerBI workspace. I am still gettting the same error. Any other ideas?

 

Thanks,

 

Stuart

Highlighted
Community Support
Community Support

Re: Analyze in Excel - 64 bit Windows and 32 bit Excel Issue

Hi @Stuart_S ,


For the issue, I cannot reproduce it here. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

 

Support Ticket .gif

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors