Forum Discussion
analyze in excel
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).
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;
I had this issue today and first I tried to download all versions of SQL_AS_OLEDB.msi that I could possibly find but nothing worked, so then I did the EXACT OPPOSITE of what you just wrote: I replaced MSOLAP with MSOLAP.7 and saved the file. And then it worked!
Yep, replacing MSOLAP with MSOLAP.7 also did the trick for me in version 1710 (build 8625.2127).
same issue with 1711 (Targeted channel), win10 64
manually changing MSOLAP to MSOLAP.7 works for me
AnonymousTried everything ... nothing worked ... EXCEPT YOUR SOLUTION! THANK YOU SO MUCH!
Anonymous This solution worked ... replacing MSOLAP with MSOLAP.7! THANK YOU SO MUCH!
I solved the issue by doing the reverse, but thanks anyway :smileyhappy:
Hi
If you run Excel as "administrator" it will work fine.
