topic Re: Change Databricks Connection on Power BI (service) in Warehousing & Analytics

Change Databricks Connection on Power BI (service)

mbhakta — Fri, 18 Aug 2023 23:57:01 GMT

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?

Re: Change Databricks Connection on Power BI (service)

mbhakta — Mon, 21 Aug 2023 21:02:34 GMT

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?

Re: Change Databricks Connection on Power BI (service)

Srushti — Tue, 28 May 2024 20:31:40 GMT

Have you got any solution for this?

Re: Change Databricks Connection on Power BI (service)

J_C — Wed, 04 Dec 2024 15:02:26 GMT

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.