OLE DB or ODBC error: [DataSource.Error] ERROR [HY000

Hi Anonymous ，

 Do you have the cloud and on-premise data sources configured in the gateway as shown below?

And try to add an  additional parameter  in the source step. Please have a try.The issue might be related to Databrick's new Cloud Fetch architecture in runtime 8.3 and above. With a cluster runtime of 7.3 the refresh on service worked smoothly for the same dataset. The issue only occurs, when merging on prem with cloud data in PBI power query and using a on prem Enterprise gateway. As 7.3 has end of support in September the fix below worked for clusters running on 10.4.

let
Source = Databricks.Catalogs("*********************", [EnableQueryResultDownload="0"]),
hive_metastore_Database = Source{[Name="hive_metastore",Kind="Database"]}[Data],
default_Schema = hive_metastore_Database{[Name="default",Kind="Schema"]}[Data],
prod_parts_atb_yearly_forecast_Table = default_Schema{[Name="prod_parts_atb_yearly_forecast",Kind="Table"]}[Data]
in
prod_parts_atb_yearly_forecast_Table

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien