Forum Discussion

juhoneyighot's avatar
juhoneyighot
Helper III
1 year ago

Parameterize dynamics finance and datasource using Power M Query

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

Tips and Tricks

1 Reply

  • suparnababu8's avatar
    suparnababu8
    Super User
    1 year ago

    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!