Leveraging Power BI Parameters to Switch Between Environments

[insafM]

Dear Community, 

I have DEV, test and prod environment in Databricks and I want to be able to switch sources between these differe,t environment 

would the parametered data source system be a possibility for Azure data bricks as well ?

[Anonymous]

Hi @insafM ,

It is possible to pass parameters to switch environments.

1.Try to create parameters to represent environments.

2.Use the baseParameters property to pass parameters to notebooks.

3.You can also view the following link to learn about the databricks.

Azure Databricks activity - Microsoft Fabric | Microsoft Learn

Best Regards,

Wisdom Wu

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

[christinepayton]

Yes, it'll work with virtually anything. You can connect to the source in the usual way, create your parameters in the query editor, and then insert them in the advanced query editor window in place of the prior text values for things like server/db. 

[insafM]

Hello @christinepayton , 

thank you for this.

it seems to be leading forward towards the solution I am looking for.

I would like to ask though, do I have to apply the changes for every table in the advanced query editor ? 
is there a way to do it all at once? ( I checked and I could not change that at the data source setting level 😞 )