Forum Discussion

jdunmall's avatar
jdunmall
Icon for Advocate I rankAdvocate I
10 years ago
Solved

Analyze in Excel: Initialization of the data source failed

Hi all,   Trying to get Analyze in Excel working. I tried it with a PBIX uploaded from desktop. I've installed the OLEDB package. I get the following error: Initialization of the data source failed...
Need Help
  • kcantor's avatar
    kcantor
    10 years ago

    I had this exact error. I uninstalled the add on and then re installed making sure to choose 64bit. After that, it allowed me to log in and export for analysis. While I had installed the correct version, a coworker installed the incorrect version. A clean install solved the issue for both of us.

jdunmall's avatar
jdunmall
Icon for Advocate I rankAdvocate I
10 years ago

Nice kcantor! Uninstalling and reinstalling worked. I'm almost positive I installed the right one the first time... but still - thank you. Sending you a virtual beer!

 

-Jeff

itchyeyeballs's avatar
itchyeyeballs
Icon for Impactful Individual rankImpactful Individual
10 years ago

I'm still getting this issue, where do you select the x64 version? I dont seem to have the option?

When I click analyse in excel I get the following

 

I have installed (and reinstalled this) but at no point does it give me the option to chose x86 or x64. Am I missing something?