Forum Discussion

insafM's avatar
insafM
Frequent Visitor
2 years ago

Leveraging Power BI Parameters to Switch Between Environments

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 ?

 

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    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's avatar
      insafM
      Frequent Visitor
      2 years ago

      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 😞 ) 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.