dataflow source change from aws redshift to databricks

Hi bhavyamalik1,

You can change the data source in your dataflow, but it requires recreating the connection. Here's how you can try to approach it:

Option 1: Edit directly in Power BI Service (Recommended)

1. Go to your workspace and open the dataflow for editing
2. In Power Query Editor, select the query connected to Redshift
3. Click Data source settings or Configure connection
4. Unfortunately, you cannot switch connector types (Redshift → Databricks) directly
5. You'll need to delete the current source step and add a new Databricks connection
6. Right-click the Source step → Delete
7. Get Data → Databricks → enter your connection details
8. Reapply your transformation steps (they should still be there)

Option 2: Use the JSON file (Advanced)

1. Open the downloaded JSON file
2. Find the data source section (look for "Amazon Redshift" references)
3. Replace with Databricks connection string format:
   • Change the connector from AmazonRedshift to Databricks
   • Update server, database, and authentication details
4. This is risky - one syntax error breaks the dataflow

Option 3: Recreate the dataflow (Safest)

1. Create a new dataflow
2. Connect to Databricks
3. Copy/paste the M code from your existing queries (from the JSON or Advanced Editor)
4. Update reports to point to the new dataflow

Best regards!

PS: If you find this post helpful consider leaving kudos or mark it as solution