Forum Discussion
Solved
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) ...
Hi 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.
v-achippa
Community Support
Community SupportHi ShreyasMungad,
We wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa