Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Feel free to share your thoughts.
Thank you in advance.
Solved! Go to Solution.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |