Forum Discussion
Problems while accessing Power BI dataset through Excel
rjrn,
In my environment, I have got 1710 update. Please contact your system administrator that if the update is automatically released to your system.
Regarding to the workaround, do you use 32bit or 64bit Excel? Please check the detailed steps below.
1. Verify excel version - 32 bit or 64 bit. Go Excel -> Files -> Account -> About Excel
2. Go to: "C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140" for 32-bit excel version or to: "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesX64\Microsoft Analysis Services\AS OLEDB\140" for 64-bit excel version
3. Right click on the adal.dll -> Properties -> Details tab and check that the 'Product version' is 1.0.2044.0414 (this is the "bad" adal version)
4. Close all office applications
5. Rename the adal.dll file to adal_orig.dll
6. Download MSOLAP 7 from here: http://download.microsoft.com/download/4/8/2/482E5799-9B8E-4724-8A4C-F301BAE788EE/13.0.3523.4/1033/x64/SQL_AS_OLEDB.msi
7. Go to: "C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\130" for 32-bit excel version or to: "C:\Program Files\Microsoft Analysis Services\AS OLEDB\130" for 64-bit version and copy the adal.dll to the location in step number 2
8. Go back to the location in step number 2 and check that the version of the adal.dll is now: 1.0.2028.318
9. Now try to open the odc file again and see if it works for you.
Regards,
Lydia
rjrn,
For your second question, this is a known issue, please try the workaround below.
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)
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)
5. Open the odc file and see if it works for you.
Alternatively, you can update your Office to 1710 version.
There is a similar thread for your reference.
http://community.powerbi.com/t5/Integrations-with-Files-and/Analyze-in-excel-system-error/m-p/278325#M13483
Regards,
Lydia
Anonymous
I did all the steps above and keep getting the same error.
Also, my Excel is version 1709, when I try to update it, it says "The latest version of Office is installed on your computer".
Any thoughts?
rjrn,
In my environment, I have got 1710 update. Please contact your system administrator that if the update is automatically released to your system.
Regarding to the workaround, do you use 32bit or 64bit Excel? Please check the detailed steps below.
1. Verify excel version - 32 bit or 64 bit. Go Excel -> Files -> Account -> About Excel
2. Go to: "C:\Program Files (x86)\Microsoft Office\root\VFS\ProgramFilesX86\Microsoft Analysis Services\AS OLEDB\140" for 32-bit excel version or to: "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesX64\Microsoft Analysis Services\AS OLEDB\140" for 64-bit excel version
3. Right click on the adal.dll -> Properties -> Details tab and check that the 'Product version' is 1.0.2044.0414 (this is the "bad" adal version)
4. Close all office applications
5. Rename the adal.dll file to adal_orig.dll
6. Download MSOLAP 7 from here: http://download.microsoft.com/download/4/8/2/482E5799-9B8E-4724-8A4C-F301BAE788EE/13.0.3523.4/1033/x64/SQL_AS_OLEDB.msi
7. Go to: "C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\130" for 32-bit excel version or to: "C:\Program Files\Microsoft Analysis Services\AS OLEDB\130" for 64-bit version and copy the adal.dll to the location in step number 2
8. Go back to the location in step number 2 and check that the version of the adal.dll is now: 1.0.2028.318
9. Now try to open the odc file again and see if it works for you.
Regards,
LydiaAnonymous
Lydia, it worked now! Thank you very much!! :smileyvery-happy:
