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
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi alvrz1908,

 

Did you solve the issue by update the OLEDB provider follow my previous post?

 

Regarding your concern about the error message, I will report it internally.

 

You can check Excel Library Update in Power BI service anytime follow IlanH's post.

 

Best Regards,
QiuyunYu

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.