Parameterize dynamics finance and datasource using Power M Query

[juhoneyighot]

Hello!

I'm still learning about PowerBI. Now, we're pulling 2 data source in finance and operations applying cross company filter. 

1. Sandbox Environment:  "https://struxdev3.sandbox.operations.dynamics.com/data/VendorsV2?cross-company=true"

2. Production Environment: "https://strux.operations.dynamics.com/data/VendorsV2?cross-company=true"

I already created  a parameter 

I'm having a hard time how to parameterize using Power M Query so I could dynamically switch between the two environments.
Please see below Advance Editor 

Hope someone could help me on this

[suparnababu8]

Hi @juhoneyighot 

Just wanted to know, where you have to change the parameter values dynamically? I would say where you will switch between the environments. Usually I follow I will change in PBI services.

Thanks!