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.

AJames's avatar
AJames
New Member
8 years ago

I am having the same issue, any update please? I also get the message:
"The following system error occurred: (The operation completed successfully.)."

  • jl20's avatar
    jl20
    Helper IV
    8 years ago

    My colleague is having the same issue. Any update?

    • jllelis's avatar
      jllelis
      Advocate I
      8 years ago

      Hi All,

       

      The lastest office update release has a correction for this issue, try to update it and see if works. If not, there is a workaround in this link: https://pbiwiki.com/wiki/TSG_-_Analyze_in_Excel look for the topic: MSOLAP 8 uses a bad adal version. Hope it helps!

       

      Best,

      João Lucas

      • jeremyhager's avatar
        jeremyhager
        Regular Visitor
        8 years ago

        Hi jllelis,

         

        It seems you've linked an interal wiki for Microsoft-tenant-only users. Can you post the workaround in this forum or on a public wiki?