Forum Discussion

urpalani's avatar
urpalani
Icon for Helper II rankHelper 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
Icon for Power BI Team rankPower 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.