Forum Discussion
Filltering published reports trough Links
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?
Do I have to buy pro or premium?
thanks in advance
4 Replies
Hi MarvinConceição ,
did you make the report publicly available through Publish to Web?
If so, can you share the url?
Here you go the url mwegener , had to make a sample table with some data
https://app.powerbi.com/view?r=eyJrIjoiNGViM2JkZWQtZDk3Ny00NDhkLThhMGYtMTYzMTllYjZjN2YyIiwidCI6ImIwZGE2ZmEzLTYwMjUtNDM0Ny04NzhiLWEwNzhhMmFiMmU3MiIsImMiOjl9
here you got a table named "VO", with the field "func", I need to filter the link according to this func
In the document limitations here: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#considerations-and-t...
"Query string filtering doesn't work with Publish to web or Export to PDF."
And I have tested on my side, it url filter is not work on my side in publish to web link.
not sure why it works on that example, it seems that it is due to that custom visuals.
Regards,
Lin
Hey mwegener , let me get a copy of the link and I'll share it here
v-lili6-msft , I've seen the documentation above, and I saw that particular restrition, still I got this working example, and what I am trying, is to understand how does it work in there, cause that would solve my problem.
seeing it could be something related to the custom visuals, can I change mine to go along with those?
