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

Power BI Report Server Passing URL Parameters for report filtering

Good evening,

 

We have published a report at the on premises Power BI Report Server. We need this report to be embedded to an on premises - as well- web application . The report should interact with the surroundings of the web app in the sense of passing parameters to the report upon users' interactions.

For the time being we test the functionality using a very plain  report, trying to pass YEAR and MONTH values to filter its data through  browser .

For instance, http://pbiserver/bireports/powerbi/Test Folder/test report? filter= Table1/YEAR eq 2020 and Table1/MONTH eq 3

 

With the url above what should I expect to happen to my table report? As you may see below, report data is not filtered by month as expected.

CID_Month_Measure.JPG

Feel free to share your thoughts.

 

Thank you in advance.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Power BI Report Server Passing URL Parameters for report filtering

This works on my machine. Do you have a space after the "filter= " ? I found that if I do that the filter just silently fails to work, while if I deliberately misspell the table name I get a warning icon over in the filters pane.


View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Power BI Report Server Passing URL Parameters for report filtering

This works on my machine. Do you have a space after the "filter= " ? I found that if I do that the filter just silently fails to work, while if I deliberately misspell the table name I get a warning icon over in the filters pane.


View solution in original post

Highlighted
Frequent Visitor

Re: Power BI Report Server Passing URL Parameters for report filtering

Thank you very much. It was the space after '?' and after '=' that were included in my url. I eliminated them and it worked just fine.

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021