Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply

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...

image.png


and the same url with
&Country=Austria
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyO...

image.png


This is what I'm trying to acchieve with my own link, does anyone knows how does this work?
thanks in advance

2 REPLIES 2
amitchandak
Super User
Super User

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?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors