cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with live connect to model in Excel - Data Driver does not include necessary capabilities

Hi, We use live connect in Excel to analysisservices model data from Power BI.  We have a user that is receiving this error when trying to select a filter option.

Data Driver does not include necessary capabilities and cannot be used with Excel.  Contact your database administrator or driver vendor.

 

Has anyone experienced this before and any suggestions?

 

Tina

 

Status: New
Comments
Community Support

Hi @tinadouglass51

 

From your description, it looks like you are connecting to Power BI desktop model within the Excel file, right? 

 

Based on my test in Excel 2016 (16.0.4966.1000) MSO (16.0.4939.1000) 64 bit, connect to Power BI desktop model with localhost:<port> follow this document, it's able to create a PivotTable and set the filter. The Power BI desktop runs on my side is 2.79.5768.1082 64-bit (March 2020). Please run the same Power BI desktop version then test again. 

 

Best Regards,
Qiuyun Yu

Frequent Visitor

Qiuyun

 

Hi, we are actually live connecting to a published model in Power BI (not desktop).  I'm not sure if that changes your feedback.  I can take a look at your link.

Community Support

Hi @tinadouglass51

 

I'm a little confused with your scenario. It seems you create a report based on a dataset in Power BI service directly, right? If it is, please go to dataset settings of this dataset, ensure both gateway connection (if required) and data source credential are set correctly. 

 

Best Regards,
Qiuyun Yu