Forum Discussion
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: 4892. Used features: Adbc.DataSource/ADBC Snowflake Driver - Go/(unknown or development build)/Snowflake/v1.17.0.. '.
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 🌀.
4 Replies
Hi Anonymous,
it might be a memory issue.
Can you try to use the task manager and see, while you are trying to import, if you have full RAM Occupied?
Best
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
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 🌀.
Hi 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.
