Forum Discussion

ShreyasMungad's avatar
ShreyasMungad
New Member
26 days ago
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) ...
Need Help
power bi
  • rajendraongole1's avatar
    rajendraongole1
    26 days ago

    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's avatar
v-achippa
Icon for Community Support rankCommunity Support
23 days ago

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