how to filter the publish to web report using query string filter?

Hi, automation 

First of all, thank you for your question! Regarding the URL filter you mentioned, its working principle is to pass the query parameters to the filter panel to achieve report filtering. The specific format is as follows:

reportId=xxxxxxxx-xxxx-xxxx-xxxxxxxxxxxx&pageName=ReportSection&filter=Table/Field eq 'value'

reportId: Identify your report.
pageName: Specify a page in the report.
Table/Field: Correspond to your table name and field name respectively.

Ultimately, this URL will pass the value to the field in the specified table, forming a page filter. As shown in the figure below, I have disassembled it:

Next, as to why "Publish to Web" does not have this function: when we publish the report to the Web, the report ID and page will be encrypted and converted, and the published report does not have a filter panel, so these values ​​​​cannot be passed to the corresponding fields.

You mentioned that you have a Pro license and your users are covered by Pro per user licenses. Actually, you don't need to publish the report to the web, you can implement report filtering by simply adding the following suffix to the report URL:

?filter=TableName/ColumnName eq 'value'

The example is shown in the following figure:

Here are the results:

In your case, just replace it with the corresponding country table/field. Finally, you should apply it directly behind the link to your Power BI report instead of publishing it to the web, which not only creates security issues, but also leaves a lot of functionality unsupported.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.