Forum Discussion

jdunmall's avatar
jdunmall
Advocate 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.

kcantor's avatar
kcantor
Community Champion
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
    Advocate 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
      Impactful 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?