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

MSAInitaite's avatar
MSAInitaite
Frequent Visitor
9 years ago

Hi 

I get the exact same error (well, in danish, but still) and I've just installede and reinstalled the OLEDB driver. 

I have another computer, on which it's not woring Either, but there Excel crashes without an error. 

 

Any other Ideas as hov to solve this? 

  • tarostok's avatar
    tarostok
    Power BI Team
    9 years ago

    Hello,

     

    I'm from Analyze in XL team and I'll be happy to help with this issue.

    Please contact me via e-mail [email protected].

     

    Thanks,

    Tal

  • xiaodong's avatar
    xiaodong
    Frequent Visitor
    9 years ago

    If you use Windows 7 or Windows 2008 R2, you can try the build 13.1.4001.0 (SQL 2016 SP1). Download the ENU\x64\SQL_AS_OLEDB.msi from https://www.microsoft.com/en-us/download/details.aspx?id=54279. I think the issue related to Windows 7 AND the latest Analyze In Excle (SQL_AS_OLDB.msi build 14.0.700.314).