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
Twan's avatar
Twan
Advocate IV
8 years ago

Has anyone been able to fix this issue for all of their users?  They all have the latest version of Analyze in Excel and the latest version of Power BI Publisher installed.  Changing the connection to use MSOLAP.8 instead of MSOLAP.7 fixes the problem for some users but not all.

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