Forum Discussion
Solved
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: [...
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.
Hi data_msfabric,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.