Forum Discussion
Anonymous
8 months agoNot applicable
OLE DB or ODBC error
Getting this error when trying to import data table: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Container exited unexpectedly with code 0x00000002. PID: 489...
- 8 months ago
Hi Anonymous,
Try it to fix:
Option 1: Update the Snowflake ADBC Driver- Install the latest stable version of the ADBC driver for Snowflake.
- Ensure it is compatible with the version of Power BI Desktop you are using.
- Official documentation:
https://docs.snowflake.com/en/user-guide/odbc
Option 2: Switch to the Official ODBC or Native Connector- Instead of ADBC, use the Snowflake native connector in Power BI or the certified ODBC driver.
- In Power BI Desktop:
Get Data → Snowflake (do not use the experimental ADBC connector).
Option 3: Validate Connection Parameters and Mode- Confirm whether you are using Import or DirectQuery.
- If using DirectQuery, test with Import to check if the issue is related to the execution mode.
- Verify that the Snowflake account has the correct permissions and that there are no network restrictions.
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
v-hashadapu
Community Support
8 months agoHi Anonymous , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.