Forum Discussion
the database driver does not include necessary capabilities in EXCEL
Hi, This may be more appropriate for an EXCEL forum, but decided to start here. We have live connect in EXCEL to a model created through Power BI. When a user selects some of the filters the...
I've run into the same issue several times, and it's caused a lot of frustration because the issue seems transient with no clear fix or troubleshooting steps.
In my case we're also using the "Analyze in Excel" feature (OLAP connection to a published Power BI dataset) and the issue seems specific to one particular filter field. When attempting to change the filter, the error message is received.
The only "solution" I've found so far is to pull the problematic field into the "Rows" section of the PivotTable, and then immediately move it back to the "Filters" section. After doing so, the filter works properly with no errors. No idea why this "fix" works...