Forum Discussion
data_msfabric
1 year agoFrequent Visitor
OLE DB or ODBC error with Databricks: Temporary Result File URL Expired
Hi Power BI Community, We're encountering the following error after migrating our data source from SQL Server to Azure Databricks and re-pointing our reports in Power BI: OLE DB or ODBC error: [...
- 1 year ago
Hi data_msfabric Switching to the Azure Databricks connector might improve stability, as it’s optimized for this use case. You could also break queries into smaller chunks or enable caching to improve performance.You can consult your Databricks admin to see if the TTL for result files can be extended to avoid timeouts.
Akash_Varuna
1 year agoSuper User
Hi data_msfabric Switching to the Azure Databricks connector might improve stability, as it’s optimized for this use case. You could also break queries into smaller chunks or enable caching to improve performance.You can consult your Databricks admin to see if the TTL for result files can be extended to avoid timeouts.