Forum Discussion
Advocate IAnalyze in Excel: Initialization of the data source failed
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.
Microsoft EmployeeWe 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
In the last week I have just started to get this error. I have downloaded the add-in, uninstalled it and reinstalled to no avail. Is there a way to force 64bit compatibility at the time of install?
AndrewSEAAdvocate II
I'm getting this when I try to use Analyze in Excel and many of my co-workers are experiencing the same. Everything was working up until a couple week ago. With so many people experiencing this, I suspect something on the backend broke?
jllelisTry to change the provide in connection string by updating the Provider=MSOLAP.7 to Provider=MSOLAP.8. Go to DATA tab >> Queries & Connections >> right click on connection name >> Properties >> Definition tab >> Connection string. I don´t think this will be a final solution, but maybe it will help for now.
Hello,
I am having issue where my analyze in excel is greyed out. Any ideas on why it is greyed out?
