Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.