Changing Databricks connection for PROD migration

[Anonymous]

How to change the data source connection to migrate code from UAT to PROD for Databricks tables? "Change source" option is disabled in power bi desktop for Databricks and can not change the same in workspace. Tried it Edit query but it is shwoing in table level connection. What is the best way to change Databricks source connection which includes "Server Host" , "HTTP Path" and "Personal Access Token"

[Anonymous]

Hi  @Anonymous  ,

In power bi desktop go to query editor, select your table and on the right hand side under Applied Steps click settings icon. You can also without going to query editor - go to File -> Options and settings -> Data source settings >Right click data sources and change source.

You can check these links to find related content:

https://community.powerbi.com/t5/Desktop/can-I-change-the-data-source-from-test-to-production-database-in/m-p/3994

https://docs.databricks.com/data/data-sources/index.html

https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.