cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Community Platform Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

Pratikmsbsvm
New Contributor

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.

1 REPLY 1

NandiniN
Databricks Employee
Databricks Employee

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group