cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

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

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors