topic Migration of PowerBI reports from Synapse to Databricks sql (DBSQL) in Get Started Discussions

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

Pratikmsbsvm — Thu, 16 Jan 2025 05:10:18 GMT

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.

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

NandiniN — Sat, 01 Feb 2025 05:10:33 GMT

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-databricks/td-p/90663

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

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.

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

Pratikmsbsvm — Tue, 03 Jun 2025 07:36:08 GMT

@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.