Sep 09 2024 08:45 AM
I connecting a pivot table to Adventure Works hosted in SSAS (16.0.42.209) from Excel Desktop (2408) and everything looks good until I'm trying to perform a drillthrough (Show Details) :
I get the following error :
Errors in the back-end database access module. The provider 'SQLNCLI11.1' is not registered.
But it seems this client stuff has been deprecated and I cannot install it. Is Drillthrough still supported in Excel against SSAS 16.x ?