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