Forum Discussion

TDouglassAFG's avatar
TDouglassAFG
Frequent Visitor
5 years ago

Error in Excel with connection to analysis services cube

Good afternoon,

 

We have multiple excel spreadsheets that connect to an analysis services cube for sales reporting.  They are all linked to the same cube and were created from the same template, however I have one report that seems to consistently give this error

"The database driver does not include necessary capabilities and cannot be used with excel".

 

This last worked successfully a couple months ago.  Does anyone ever have this error before and recommendations on where to look?

 

 

Need Help

2 Replies

  • Jimmy801's avatar
    Jimmy801
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hello TDouglassAFG 

     

    do you use a connection in the workbook and the report is a Pivot table or are you using queries to read dimensions from the cube?

     

    Jimmy