How to add SSRS-like report parameters to Power BI report?

[Anonymous]

I would like my Power BI report to present the user with a parameter (e.g. CompanyNumber). Once the user selects or enters the company number, I want this value to be used in the SQL query that is executed to bring back the report data.

How can this be done?

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I assume that you want to use query parameter to transform different data based on the data from data source. I created data to reproduce your scenario. 

Table:

You may go to 'Query Editor'=>'Home', 'Manage Parameters', create a parameter like below.

Then you can use the paramter to filter rows as below.

Finally users can modify the parameter to filter the report by clicking 'Transform data'=>'Edit parameters'.

About query parameters, I'd like to suggest you refer to the following links.

Deep Dive into Query Parameters and Power BI Templates 

Power BI Desktop Query Parameters 

Best Regards

Allan

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

[amitchandak]

@Anonymous , refer if this can help

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-parameters