Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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