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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.