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

alvrz1908's avatar
alvrz1908
New Member
9 years ago

Hi v-qiuyu-msft

 

I did get once instance resolved, but updating the OLEDB provider did not actually resolve it. The only way I got it resolved was actually be uninstalling and reinstalling the entire Microsoft office suite and basically starting over. This was very time consuming, so I really hope this bug gets resolved.

 

I also had other colleagues install the OLEDB provider and it still lead to the error message. I then added my file to a separate workspace and one user was able to analyze in excel, the other could not. So honestly, this has been really hard to pinpoint. Any users under the same office 365 service and Power BI with should be able to open .odc file from my Power BI workspace right?

 

This analyze in Excel feature is probably the single most important feature of Power BI, so it has been incredibly frustrating not having other users open the .odc file and successfully access the linked data. Can you please prioritize this? I am happy to work directly with any associates at Microsoft. 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi alvrz1908,

     

    Analyze in Excel feature has some requirements, you can review it before use this feature. for your feedback, you can contact the tarostok who comes from the Analyze in Excel team.

     

    Best Regards,
    QiuyunYu

  • James_W_Myers's avatar
    James_W_Myers
    Frequent Visitor
    8 years ago

    Just had the same issue which remains unresolved - Why does Analyze in Excel not use Power Query, think it would be easier to use and hopefully not have the same issues?