The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
@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 changes
https://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=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyO...
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyO...
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
119 | |
86 | |
75 | |
55 | |
44 |
User | Count |
---|---|
136 | |
128 | |
78 | |
64 | |
63 |