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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

@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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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