Parameter in Power BI (Desktop and Power Query)

Hi, Mdived 

We can use parameters in Power Query for many purposes, such as filtering our queries through parameters:

We can also use parameters as parameters for connecting to a data source. For example, when we connect to a database, we define the database name in the parameters and then use it when connecting:

We can also use parameters created by PowerQuery in the Advanced Editor:

For example, when we want to use incremental refresh of the Power BI semantic model, we need to use the parameters in Power Query.

Power BI desktop field parameters allow users to dynamically change the measure or dimension being analyzed in a report. This feature helps report readers explore and customize the analysis of a report by selecting different measures or dimensions that they are interested in.

As I created a field parameter in the image above, this parameter will interact with my visual object.

You can learn more about the differences between them from the following links:

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Parameters - Power Query | Microsoft Learn

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

Power Query Parameters Vs. What If Parameters: Power BI Implementation Use Cases - RADACAD

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.