Excel Drillthrough Broken : SQLNCLI11.1 not registered

Copper Contributor

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 ?

0 Replies