Forum Discussion
PowerBi published in PowerBi report Server Direct link
Hi,
Thanks for your reply.
All clear about first part of your answer.
About second part, i found the way to apply the filter via url: After your URL, you have yo add (using fields in you example):
?filter=[Table/animal eq 'cat'
The filter will be appear in the filter pane on the right.
Best Regards
Hi,Anonymous .Thank you for your reply.
If you are targeting Power BI Service
then your requirement can be realized, but not in the report server.
By creating a button in the report with a web URL jump function, you can specify the page to be displayed when the report is opened while passing the field filtering criteria.
this is my test measure:
For the report URL in Power BI Service, it contains information such as gourpID, reportID, PageID, and filter fields.
PageJumpURL1 =
"https://app.powerbi.com/groups/yourgroupID/reports/2825de85-adf5-4e84-bd8b-ea0514420a29/"&[PageURL1]&"?filter=datarefreshTest%2Fanimal%20eq%20%27"&[SelectAnimal]&"%27"
PageJumpURL2 =
"https://app.powerbi.com/groups/yourgroupID/reports/2825de85-adf5-4e84-bd8b-ea0514420a29/"&[PageURL2]&"?filter=datarefreshTest%2Fanimal%20eq%20%27"&[SelectAnimal]&"%27"
My pageURL (the pageURL is fixed for each page of the report, you can get the pageURL for each page of the report by copying the URL in the service)
PageURL1 = "d1cba0b7d3c7ab466150"
PageURL2 = "eba9e747ea0da7e5db78"
You can see that each page of a report has a different pageID.
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
But the report server doesn't support it, as you can see no matter which page I click on, there is no modification of the page parameter (there is no page parameter in the URL), which is also mentioned in my previous reply
So your needs are perfectly realized in power BI Service, but not in Power BI Report Server (I recommend you to write scripts to directly modify the front-end page code, so as to change the number of report pages displayed by default when the report is opened).
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian