SAP HANA to Databricks Migration

[Anandhu12]

Can we change the connection in a PBI report or dashboard from SAP HANA to Databricks will it work without any issues?

[rajendraongole1]

Hi @Anandhu12 -while the migration from SAP HANA to Databricks is possible, it involves reworking queries, optimizations, and security considerations. Testing and validation are essential to ensure a smooth transition. Depending on the complexity of the existing SAP HANA setup.In Power BI, navigate to "Transform Data" > "Data Source Settings" and modify the connection details to point to your Databricks cluster instead of SAP HANA.Rebuild Queries: If necessary, update any queries or Power Query transformations that rely on SAP HANA SQL to be compatible with Spark SQL in Databricks.Validate: Ensure that all visuals, filters, and calculations work as expected with the new data source.

reference links:

SAP HANA to Databricks Migration - Microsoft Fabric Community

Integration Options for moving data from SAP into ... - SAP Community

Hope the above information helps.