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
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;

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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!

  • mcharing's avatar
    mcharing
    Frequent Visitor
    8 years ago

    Yep, replacing MSOLAP with MSOLAP.7 also did the trick for me in version 1710 (build 8625.2127).  

    • mrzap000's avatar
      mrzap000
      New Member
      8 years ago

      same issue with 1711 (Targeted channel), win10 64

      manually changing MSOLAP to MSOLAP.7 works for me

    • Jacky's avatar
      Jacky
      Frequent Visitor
      8 years ago

      Yes, for me as well.

  • dler's avatar
    dler
    Regular Visitor
    8 years ago

    AnonymousTried everything ... nothing worked ... EXCEPT YOUR SOLUTION!  THANK YOU SO MUCH!

  • dler's avatar
    dler
    Regular Visitor
    8 years ago

    Anonymous  This solution worked ... replacing MSOLAP with MSOLAP.7!  THANK YOU SO MUCH!

  • mrzap000's avatar
    mrzap000
    New Member
    8 years ago
    Anonymous wrote:

    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!

    it worked for me too - great suggestion!

  • Mike_Carlo's avatar
    Mike_Carlo
    Most Valuable Professional
    8 years ago

    I was also having this issue. When I opened the file it was already formatted with Provider=MSOLAP,   I was able to replicate what Anonymous did in the file by adding .7, so now it reads Provider=MSOLAP.7 After this change I am able to load the odc file and use analyze in excel... IlanH what version of excel were you using?

     

    I am using Excel 2016 MSO 16.0.8730.2046 64-bit

    and just this morning installed the lastest version of OLEDB

    x64_1033_3291099_SQL_AS_OLEDB

     

    tarostok  Is there any reason why this would be causing an issue?  Why would my newer 2016 version of excel require the MSOLAP.7?  It is difficult to work with the analyze in excel function if I have to change every odc file I download from the service.