Forum Discussion
Publish to Web Public URL Filtering
Hello dear community members,
I have a question which I have spent lots of time to implement but could not find the answer. Simply, I have a report that I published to public and intergrate it to the website. I need to find a way to filter the report by the url link. Following example, I have found out in the forum but could not find the answer how is this designed. Is there anyone done this before, would be appreacited! 🙂
Example:
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyOGQyZTEyLTA5ODgtNGFjZi1iZGJhLTExOTU4MmU4ZDA4ZCIsImMiOjl9&Country=Austria
Not: When you change the Country=Spain for example, it is filtering the Spain
2 Replies
Without seeing the report builder behind your example, it's difficult to say for certain, but my guess would be the Country name you are passing isn't a filter but is instead a "page" name in the report. It looks like each country in this example report has it's own page, but you aren't applying a filter through the URL. So this method won't work in your case unless you also separate the different cases out to different pages.
Instead, you could try using this filter format on the URLs: Power BI URL Filters made easy - PowerPlatformLearn | Rory Neary
Which should be basically something like this:
https://www.exampleurl.com/$reportid=fjdfksd-fsdkffjs-dfjsdfksjdf&$filter=TABLENAME/COLUMNNAME in ('Value1','Value 2')But the example report I have shared from Politico is not having this page by page feature and it works exactly as I wanted to. Publish to Web (Public) and filtered by the URL simple exampleurl......&Column=value. Please see the below link agaian and change the parameter also make sure that report links including view?r=...
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyOGQyZTEyLTA5ODgtNGFjZi1iZGJhLTExOTU4MmU4ZDA4ZCIsImMiOjl9&Country=Austria
