cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
durgaranga Frequent Visitor
Frequent Visitor

Parameters to a Power BI report in Power BI Report Server

Hi Team,

 

I need to create a power BI report and provide user to input parameters of there choice so that they will get desired results from a query which is connectiing to Teradata DB. My clients want this feature in high demand.

 

Ex: End user wants to select the data of customers who are in a particular city. Now end user needs to provide only city name as input parameter and she needs to get the result of the customers who live in that city.

 

Below is the query which needs to be run in backend by connecting to Teradata DB.

 

Select * from customers where city_name= ${input_parameter}.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
rajendran Super Contributor
Super Contributor

Re: Parameters to a Power BI report in Power BI Report Server

You can use parameters, so the users can input their values and data can be filtered accordingly.

 

In Query Editor -> Home -> Manage Parameters -> New Parameter.

 

You can read abt the parameter and use for your case.

 

Thanks

Raj

View solution in original post

3 REPLIES 3
Highlighted
rajendran Super Contributor
Super Contributor

Re: Parameters to a Power BI report in Power BI Report Server

You can use parameters, so the users can input their values and data can be filtered accordingly.

 

In Query Editor -> Home -> Manage Parameters -> New Parameter.

 

You can read abt the parameter and use for your case.

 

Thanks

Raj

View solution in original post

rajendran Super Contributor
Super Contributor

Re: Parameters to a Power BI report in Power BI Report Server

Hi @durgaranga

 

Go to the query in Query editor-> select the column you want to apply filter -> ex: select Equal to Filter -> The below window will appear, click on the down arrow in the middle box and select the Paramters to apply the parameter to th database columns.

 

Hope this helps.

 

Parameter.PNG

 

Thanks
Raj

elvede Frequent Visitor
Frequent Visitor

Re: Parameters to a Power BI report in Power BI Report Server

I've got the same challenge.

In powerbi desktop i made a report containing a parameter (made via edit queries/manage parameters)

I saved the report to my on-premise report server and i expected that my users could set another value in that parameter.

 

Unfortunetely my users do not have any option to change the parameter's value, they should have i suppose ? or maybe i should  set any option to pop-up the parameter ?

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,132 guests
Please welcome our newest community members: