Forum Discussion
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) Connection failed with error: Could not refill buffer
I have already tried to reduce the size of the output by reducing the date range in SQL Query, cleared cache. The only step applied in power query is converting text to date for a date column. This error has started occuring after I replaced a column with another in Query.
The query loads correctly in Databricks, the power query preview loads as well, the problem occurs only after "Close & Apply"
New to this forum, I have tried looking for solutions on Copilot, nothing helps if any ideas please let me know, I will be very grateful
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.
3 Replies
- rajendraongole1
Super User
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-achippaCommunity Support
Hi ShreyasMungad,
Thank you for reaching out to Microsoft Fabric Community.
Thank you rajendraongole1 for the prompt response.
As we haven’t heard back from you, 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- v-achippa
Hi 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