Change Databricks Connection on Power BI (service)

[mbhakta]

We're creating a report with Power BI using data from our AWS Databricks workspace. Currently, I can view the report on Power BI (service) after publishing. Is there a way to change the data source connection, e.g. if I want to change the data source from Dev to Prod data or a different workspace? 

[mbhakta]

Hi @Retired_mod,

Thanks for your reply! It seems possible, but I'm stuck on step 3, since `extensionDataSourcePath` is greyed out. Everything else is editable. What permissions do I need in order to update that field? 

 

[Srushti]

Have you got any solution for this?

[J_C]

In the Power BI transform data view, you should be able to access the M-Query code and actually change the server and the host directly. My recommendation is to create a couple of parameters to keep this info for all your queries. Then you can just change these once to change your databricks source.