Forum Discussion
urpalani
9 years agoHelper II
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...
IlanH
8 years agoMicrosoft Employee
Excel click to run version include adal.dll version with bug in Analyze in Excel scenario.
Every Excel click to run installation will bring this adal.dll version.
To resolve this Excel must update adal.dll with fixed version.
As written in this thread there are 2 possible workarounds
1) Replace Excel click to run adal.dll - this need to be repeated after every Excel click to run update.
2) manually changing MSOLAP to MSOLAP.7 - the reason this work is that msolap.7 is using adal.dll without the bug
Good news: Excel are in the final stages of releasing updates with fixed adal.dll. Should be available by mid Jan.
Sorry for the inconvinience