Problem with analysis to excel

[itay992]

Hello everyone,
I have a problem with analysis to excel

Error Message in excel:

"Initialization of the data source failed. Check the database server or contact your database administrator."

Data:
Computer with win 10 64 bit

Microsoft Excel 2013 32 bit

Analyze in excel updates: x64_15.0.2000.20_SQL_AS_OLEDB.msi‬ (Can't find a 32 bit)

Thank you.

[v-lili6-msft]

hi, @itay992 

Try the following workaround:

1. Download MSOLAP 7 from here: http://download.microsoft.com/download/4/8/2/482E5799-9B8E-4724-8A4C-F301BAE788EE/13.0.3523.4/1033/x...

2.    Close all office applications

3.    Go to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140 and rename the adal.dll to adal_orig.dll (if you have excel 64 bit use the version from Program Files / ProgramFilesX64)

4.    Copy the adal.dll from here: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\130 to: C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140  (if you have excel 64 bit use the version from Program Files / ProgramFilesX64)

5.    Open the odc file and see if it works for you

Regards,

Lin

[itay992]

Hi, thanks for the answer

Unfortunately it doesn't work.
The File Location it provided was incompatible with me, I tried the steps elsewhere but with no success.

The location of files on my computer:

https://imgur.com/VeORVSn

https://imgur.com/4txwqES

Where I tried to do the actions, but no folder "140"

https://imgur.com/R3vVBDM

Thanks.