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
AndrewSEA's avatar
AndrewSEA
Advocate II
8 years ago

That didn't seem to fix the problem.  Many of my report users are experiencing the same problem.

 

I'm on Windows 10, and using Office 365 Pro Plus (64 bit).

IlanH's avatar
IlanH
Microsoft 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;