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.

IlanH's avatar
IlanH
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

We have just release an improvement to "Analyze in Excel" setup/download experience

1) 1 download link - we auto detect the OS (operating system) bit-ness (32 or 64 bit) and accordingly provide 1 download link

2) Download menu - when you choose "Analyze in Excel" from the download menu you get a dialog with 1 download link (we auto detect the right link) and link to "Analyze in Excel" help page

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello,

I am having issue where my analyze in excel is greyed out.  Any ideas on why it is greyed out?