How to create parameterised Reports in PowerBI similar to what we have in SSRS

[bhanu431]

Hello,

How to create parameterised reports(more than 1 parameter)  in PowerBI which are similar to SSRS pameterised reports.

And if parameterised reports are possible to create in PowerBI Desktop, can we publish them in PowerBI Service??

Regards

Bhanu

[v-yulgu-msft · Accepted solution]

Hi @bhanu431,

We are able to create single parameter or multiple parameters in Power BI. But the Power BI parameterised report is not exactly the same as SSRS parameterised report. The parameter in Power BI works similar to dataset parameter in SSRS. 

As of now, parameters can only be added to your data model queries in the Power BI Desktop (PBID) tool, this functionality is not available when using Power BI service. When deploying a report with parameters to Power BI service, the current selected value for the parameters are used and cannot be changed online.

Reference: Using Parameters in Power BI

                  POWER BI DESKTOP QUERY PARAMETERS, PART 1

Best regards,

Yuliana Gu