Forum Discussion
Fillter published reports trough Link
Hi everyone,
I need to filter a report I have published to web, but I can't seem to get how does this works.
I got an error saying the report is not available, or it just opens it without being filtered.
while I was looking for a way to do this I got to this thread:
https://community.powerbi.com/t5/Developer/URL-Filter-to-Publish-to-Web-Report/td-p/678444
The author has a similar problem and says that the links that where given to him weren't available anymore.
One of the comments say:
Hello @mlarab ,
Have you found the solution?
I know that you could do it but I do not how, see below an example:
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyO...
The "Country" is parameter and the name of country a variable, if you change to belgium the data will change as well.
Thanks,
Salva
The link he gives in his example does exactly what I need
Here's the example:
havin the end of the url with
&Country=Belgium
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyO...
and the same url with
&Country=Austria
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyO...
This is what I'm trying to acchieve with my own link, does anyone knows how does this work?
thanks in advance
2 Replies
MarvinConceição , I did not got it completely
refer if this can help
https://docs.microsoft.com/en-us/power-bi/service-url-filters
Hey amitchandak, thanks for the reply
I've been trough this link, and this dosen't have solve the problem I have in hand
I need to filter the link in my published report, in a way that If I change the value, the data shown in the published report changeshttps://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
this link only explays how to do this to power bi web, but I need it on a web published report like the one in the example
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyOGQyZTEyLTA5ODgtNGFjZi1iZGJhLTExOTU4MmU4ZDA4ZCIsImMiOjl9&Country=Austria
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyOGQyZTEyLTA5ODgtNGFjZi1iZGJhLTExOTU4MmU4ZDA4ZCIsImMiOjl9&Country=Belgium
same link to web published report, being filtered trough the field Country
I don't know how they did it, does it need a diferent version? like premium or such?
