Forum Discussion
ODBC: ERROR [02000]
We recently starting getting the same message too. But the error only seems to show up in PowerBI Desktop. The nightly refreshes in our service work just fine. As was mentioned, we did find that switching to native queries does work. But we don't consider this a long term solution. It feels like there has been some recent change that has caused this.
Note - our admin noticed that if you just hit refresh a couple of times, it eventually works. But it will error again in the future.
Hi, Yes,It started after upgrade of Power BI to July2024 version. The issue is with Power M query setting not matching with default snowflake warehouse. e.g. in my case my default snowflake setting is "DEV" for Warehouse , ROLE, DB and error occurs when I am running Power BI query for "TEST".Changing Power M query to native it enforces the parameterized Warehouse , ROLE, DB.
I have reverted my Power BI desktop version to April-2024 and everthing is fine.
I have raised an issue with microsoft team but still they haven't accepted it as an issue.
um , so the reverting works , isnt it?
