Forum Discussion
ShreyasMungad
18 hours agoNew Member
Refill Buffer Error while refreshing a table
The power bi has tables connected to Databricks SQL Server While refreshing 1 of the tables getting this error: OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [08S01] [Microsoft][Hardy] (115) ...
rajendraongole1
Super User
17 hours agoHi ShreyasMungad -I'd recommend first revert the column and test Close & Apply. Since the failure appeared immediately after the column replacement, that's the highest-value test. If it still fails, switch the Databricks connection to ADBC (Implementation="2.0"), because the error is occurring during the actual data transfer rather than SQL execution. Microsoft currently recommends testing ADBC for Databricks connections.
Configure ADBC or ODBC driver for Power BI - Azure Databricks | Microsoft Learn
Hope this helps.