Forum Discussion
analyze in excel
Hello,
Please download the following MSOLAP verison and install, it should fix your issue:
Thanks,
Tal
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).
I solved the issue by doing the reverse, but thanks anyway :smileyhappy:
Hi
If you run Excel as "administrator" it will work fine.
i applied the latest link from tal.... it fixed it for one day and then when the computer restarted it we get the same error again
very frustrating.... is there any updates
So after working with the Analyze in Excel team, it looks like the version of ADAL.DLL being used is the culprit. They are working on a solution. Don't know when it'll be released, but they figured it out.
I installed Visual Studio 2017 Enterprise, and it seemed to fix the problem for me because it probably overwrote the ADAL.DLL.
