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
IlanH's avatar
IlanH
Microsoft Employee
8 years ago

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

 

 

  • Jacky's avatar
    Jacky
    Frequent Visitor
    8 years ago

    Hi,

    For me chanigng to OLAP7 did not resolve the issue.

    Can we please have an update as soon as the fix was released ?

    • lndnbrg's avatar
      lndnbrg
      Resolver III
      8 years ago

      With my newest Excel 365 Build 8827.2117 Click-and-run (Monthly Channel) it seems to just work now.

       

      Have reinstalled the OLEDB driver from the Power BI website and now it JUST WORKS.

       

      Can anybody confirm this? Or is it a coincidence?