Forum Discussion

garynorcrossmmc's avatar
garynorcrossmmc
Icon for Advocate IV rankAdvocate IV
1 year ago

Azure DataBricks Refresh Failure on Power BI Service with On-Premises Gateway

Hi Fabric Community, Our team recently moved from a Synapse SQL db to DataBricks.  Overall, it's been kind of wonky to use in Power BI, but mostly manageable except for refreshing on Power BI Serv...
Need Help
sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
1 year ago

Hi garynorcrossmmc ,
your error message gave you the hint Gateway...DataAccessError and ODBC.
How do you access your DBX environment?
Via a ODBC connection or using the native Azure Databricks connector?

Maybe there are parallel processes which interrupt eachother or your gateway cannot handle the data due to a lack of resources.

There are many possible reasons in the chain.
I use the native connector and data refresh in Service is quite fine (via gateway).

Regards.