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