Forum Discussion

thinkpad's avatar
thinkpad
Regular Visitor
2 years ago
Solved

Power Query filters and Parameters

Hi Team,   I have a small doubt. i.e  I applied the parameters in power query by adding the Canada country as parameter and then in power bi desktop i can see only Canada data it's fine. But the...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Parameters can me modifed from outside the semantic model. Filters can only be modified inside the semantic model.  That makes parameters useful for CI/CD etc.

lbendlin's avatar
lbendlin
Super User
2 years ago

What are you ultimately trying to achieve?

thinkpad's avatar
thinkpad
Regular Visitor
2 years ago

I'm trying to understand the difference here b/w Parameters and filters at power query. for me getting both o/p as same

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Parameters can me modifed from outside the semantic model. Filters can only be modified inside the semantic model.  That makes parameters useful for CI/CD etc.