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 possi...
Need Help
Tips and Tricks
Tutorial Requests
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 😞 )