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.

AndrewSEA's avatar
AndrewSEA
Icon for Advocate II rankAdvocate II
8 years ago

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?

jllelis's avatar
jllelis
Icon for Advocate I rankAdvocate I
8 years ago

Try 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.