Changing source for reports SQL Server to Databricks

Hi GavC ,

Thanks for sharing your scenario, this is a common use case when transitioning from SQL Server to Databricks.

Since you’ve maintained the same table structures, it's logical to expect a smooth switch. However, Power BI doesn’t allow you to directly swap a data source like SQL Server to Databricks without some rework, especially since the data connectors and query folding behaviors differ.

Here’s what you can do to retain your existing report and minimize rework:

1. Open Power BI Desktop.
2. Go to Transform Data > Advanced Editor in Power Query.
3. Copy the entire query for each table (from SQL Server).
4. Connect to your Databricks source and load the same tables.
5. In Power Query, for each Databricks-loaded table.
• Replace the default query with the one you copied from SQL Server.
• Just update the Source step to point to Databricks (adjust the connector and database path only).
6. Ensure all columns/data types remain consistent.

This way, you’re reusing the transformations but simply changing the backend. If names and schemas are identical, Power BI visuals should work without breaking.

You can also right-click your original SQL Server queries and use “Reference” instead of “Duplicate,” so updates can cascade if needed.

Let me know if you’d like a sample structure or a mock walk-through! You don’t need to rebuild your report from scratch just align the source steps.

If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.

Thank's,
Akhil.