topic Re: the database driver does not include necessary capabilities in EXCEL in Developer

the database driver does not include necessary capabilities in EXCEL

tinadouglass51 — Thu, 09 Apr 2020 16:37:40 GMT

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 are receiving the error

"the database driver does not include necessary capabilities and cannot be used with Excel. Contact your data administrator or Driver Vendor"

Has anyone had this before? Is there Drivers that need to be downloaded on his desktop?

Tina

Re: the database driver does not include necessary capabilities in EXCEL

Greg_Deckler — Thu, 09 Apr 2020 18:41:53 GMT

So you have Excel and you created a Live data connection to a Power BI dataset?

I would make sure their Excel is up-to-date

Re: the database driver does not include necessary capabilities in EXCEL

Greg_Deckler — Thu, 09 Apr 2020 18:42:05 GMT

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Re: the database driver does not include necessary capabilities in EXCEL

Anonymous — Wed, 24 Jun 2020 15:12:06 GMT

Any solution for this issue ??

Re: the database driver does not include necessary capabilities in EXCEL

ebeery — Thu, 10 Jun 2021 18:28:09 GMT

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

Re: the database driver does not include necessary capabilities in EXCEL

TDouglassAFG — Wed, 18 Aug 2021 12:19:34 GMT

I also receive this error alot and had to rebuild a report because of it. Sometimes I can just refresh. I agree with the suggestion below that it is usually due to records selected in the filter and how the refresh works.

Re: the database driver does not include necessary capabilities in EXCEL

Anonymous — Tue, 01 Feb 2022 11:25:32 GMT

Hi,

Possible reason can be a change in your data(set).
Best way to solve this: Clear cache excel and refresh your data connection/query.
If still not fixed, make sure that the variables used have the same name as in your dataset.
This solved the issue for us.

Kind regards

Re: the database driver does not include necessary capabilities in EXCEL

Anonymous — Wed, 08 Jun 2022 11:38:04 GMT

any solution for this?

Re: the database driver does not include necessary capabilities in EXCEL

LindsayK — Wed, 21 Sep 2022 19:04:25 GMT

Hi Tina,

I was getting the same error in Excel (not Power BI) and was able to fix it. It was happening only when I had table variables above a WITH, with several subqueries beneath.

What I did to solve the problem was to simply type "SET NOCOUNT ON" at the very top of the query above all the rest of the code.

Even if you do not have a table variable or a WITH, anyone could try to type this at the top of their code and see if it resolves their issue.

Hope this helps someone.

Lindsay

Re: the database driver does not include necessary capabilities in EXCEL

pirdim — Fri, 13 Jun 2025 11:09:11 GMT

I had similar error which was accompanied with another error that some blank element was parsing to the slicer/filter. So the only "solution" or workaround which worked for me was to find every slicer where I had actively selected (Blank), remove it from selection and then make an update to my data model. This way I didn't get that error