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