Change Databricks Connection on Power BI (service)

mbhakta
New Contributor II

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
New Contributor II

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? 

Screenshot 2023-08-21 134828.png

 

Srushti
New Contributor II

Have you got any solution for this?

J_C
New Contributor II

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.