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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.