Forum Discussion
how to filter the publish to web report using query string filter?
Hi, automation
You can check out the tutorial below and note that this method is not in the official technical support direction.
URL based navigation for a report shared via 'Publish to Web' - Power of Business Intelligence
You need to decide for yourself whether you need to try it or not. That's all I can help you with so far. If you have any questions about Javascript, you need to consult the developer platform. Seek help with your writing.
I think the following should help you:
Tamper-proof URL parameters with JWTs
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.
Anonymous/ GilbertQ
It seems that no one knows the rationale behind this. From what I gather, the URLs below are working directly with Power BI Embedded Public URLs and are filtering reports using Query String Parameters.
- &Country=France: Link_with_France_Country
- &Country=Italy -> Link with Filtering Italy Country
- &Country=Spain -> Link with Filtering Spain Country
It's really surprising to me that the official documentation differs from the user-implemented version! 😁
Hi, automation
Thanks for the feedback! As you said, this feature is really made possible by Power BI Embedded. You don't need to publish the report to the web, just share the link and set URL filters, or control the slicer options by writing a JavaScript script.
If you've already found a solution, feel free to mark your reply or a helpful response as a solution so that other community members can benefit from your experience as well.
Thank you for your cooperation and understanding!
Best Regards
Jianpeng Li
I haven't found the solution that has been implemented below.
- &Country=France: Link_with_France_Country
- &Country=Italy -> Link with Filtering Italy Country
- &Country=Spain -> Link with Filtering Spain Country
- &Country=France: Link_with_France_Country