Forum Discussion

urpalani's avatar
urpalani
Icon for Helper II rankHelper 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
Icon for Community Support rankCommunity Support
9 years ago

Hi urpalani,

 

To use Analyze in Excel, the computer must have a current AS OLE DB provider installed. Please check whether you need to update your Excel libraries for OLE DB provider follow this article: Update Excel libraries for the OLE DB provider.

 

Also you can check if the Power BI service Sample dataset is working with Analyze in Excel feature. In Power BI service, you can Get Data -> Samples -> Retail Analysis Sample.

 

Best Regards,
QiuyunYu

alvrz1908's avatar
alvrz1908
New Member
9 years ago

Hi QiuyunYu,

 

Thanks for much for this. I was having the exact same issue. Can you please inform the Power BI team to improve the error message so that it leads to the fix? The text of the error message itself is also very confusing.

 

This also seems to be an issue triggered by installing Power BI Publisher fo Excel. Once that was installed before the Excel Library update, for whatever reason it removed the prompt for new Power BI users to install the needed Excel Library Update. Without that prompt, there was a lot of confusion around the error message.

 

Thanks,

Sergio