Migration of PowerBI reports from Synapse to Databricks sql (DBSQL)

[Pratikmsbsvm]

We have 250 powerbi reports build on top of Azure Synapse, now we are migrating from Azure Synapse to Databricks (DB SQL). How to plan for cutover and strategy for PowerBI

I just seeking high level points we have to take care for planning. Any techie who did this in past, kindly share their design approach.

[NandiniN]

While your account Solution Architect (SA) will be able to guide you, if you still want to check what peers did here https://community.databricks.com/t5/warehousing-analytics/migrate-azure-synapse-analytics-data-to-da...

and here https://community.databricks.com/t5/data-engineering/migrating-data-from-synapse-to-databricks/td-p/...

I would suggest use tools like Azure Data Factory (ADF) to copy data from Azure Synapse to Azure Data Lake Storage (ADLS) and then load it into Databricks. Alternatively, use the Azure Synapse connector to directly query and load data into Databricks.

Then, Update PowerBI reports to point to the new Databricks data sources. This involves changing the data source connections in PowerBI to use Databricks SQL endpoints.

[Pratikmsbsvm]

@NandiniN : Thanks a lot. I am pretti new to data world. Can you just provide what additional benefit Databricks can provide, and how realtime streaming support by Databricks. That would be very helpful.