Forum Discussion

urpalani's avatar
urpalani
Helper II
9 years ago

analyze in excel

Hi,   When i download the data in Excel - Analyze in excel ,I am asked for credentials but after that it popups "The Following Error Occured:(The Operation Completed Successfully) , When i click ok...
Need Help
tarostok's avatar
tarostok
Power BI Team
8 years ago

Hello, 

 

For those who still experiance the issue after changing the connection to MSOLAP.8 please try the following:

  1. Download MSOLAP 7 from here: http://download.microsoft.com/download/4/8/2/482E5799-9B8E-4724-8A4C-F301BAE788EE/13.0.3523.4/1033/x64/SQL_AS_OLEDB.msi
  2. Close all office applications
  3. Go to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140 and rename the adal.dll to adal_orig.dll (if you have excel 64 bit use the version from Program Files)
  4. Copy adal.dll from here: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\130 to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140  (if you have excel 64 bit use the version from Program Files)
  5. Open .odc file and see if it works for you.
eliorb's avatar
eliorb
Frequent Visitor
8 years ago

It works, but after you close the file and open it again the connection is back to MSOLAP.7 and  then it does not work again.

  • digowaddington's avatar
    digowaddington
    Regular Visitor
    8 years ago

    Hello guys,

     

    I´m still experiencing this error. It started on September and I´ve tried all the solutions listed here.

    In the beggining they´ve worked, but only for a short period of time. Then the error started showing again.

    I need a real and solid solution for it. Analyze in excel feature is one of the best things on BI, and I need it on my day-a-day routine. 

    • Twan's avatar
      Twan
      Advocate IV
      8 years ago

      The method mentioned earlier in the thread about replacing the adal_orig.dll file has worked for my end users.  Here are the steps:

       

      1. Download MSOLAP 7 from here: http://download.microsoft.com/download/4/8/2/482E5799-9B8E-4724-8A4C-F301BAE788EE/13.0.3523.4/1033/x...
      2.    Close all office applications
      3.    Go to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140 and rename the adal.dll to adal_orig.dll (if you have excel 64 bit use the version from Program Files / ProgramFilesX64)
      4.    Copy the adal.dll from here: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\130 to :C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140 (if you have excel 64 bit use the version from Program Files / ProgramFilesX64)
      5.    Open the odc file and see if it works for you
      • tarostok's avatar
        tarostok
        Power BI Team
        8 years ago

        Hello,

         

        If someone still experiances issues with Analyze in XL please send me an email and I will be happy to help you resolve the issue via Skype, my email is - [email protected].

         

        Thanks,

        Tal