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?
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
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.
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.