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

We think we found the issue and will fix it soon in PowerBI.com (end of week)

 

Below is a workaround: in the odc file, change MSOLAP.7 to MSOLAP

1) Open *.odc file Analyze in Excel created in powerBI.com

2) Search MSOLAP

3) Change MSOLAP.7 to MSOLAP

Before: Provider=MSOLAP.7;

After: Provider=MSOLAP;

17843's avatar
17843
Regular Visitor
8 years ago

I solved the issue by doing the reverse, but thanks anyway :smileyhappy: