Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
AmrutaKar
Frequent Visitor

How to allow users to input parameters to a power bi report

I have created a SQL server dashboard using parameters , that takes the server name and builds the dynamic report. However, I would like users to input the parameters to the power bi report, when the report is opened.  So I would like to have a pop up window appear, that would allow users to input the server name and then load the reports. 

 

Please let me know, how can i achieve this.

 

Thanks

Amruta

 

3 REPLIES 3
amitchandak
Super User
Super User

Refer if this can help

https://dataveld.com/2018/04/30/build-collapsible-slicer-pane-power-bi/

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

@amitchandak  - Thank you for your quick response, but i dont think  the link answers my question. So just to ellaborate, I have a report that queries many servers and gets the server state , like the  drive space, the space occupied by data and log files , backup date etc , and to make this report dynamic, I have used parameters. But  I want to edit the parameters , from a pop up window  that will accept the server name i type as the parameter and then load the report.  So that need popup screen needs to appear when i open the report and then loads  the report on the basis  of what the user has typed.

 

If there is anything you could suggest, it would be much appreciated.

 

Thanks

Amruta

 

Hi @AmrutaKar ,

 

Check the following documents about report templates in Power BI Desktop and template apps in Power BI Service and see if it helps.

https://docs.microsoft.com/en-us/power-bi/desktop-templates.

https://docs.microsoft.com/en-us/power-bi/service-template-apps-overview.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

 

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.