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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mlarab
New Member

URL Filter to Publish to Web Report

Hi,

 

How could I filter data through the URL in a report "publish to web"?

 

I have read this message but some links are broken:

https://community.powerbi.com/t5/Service/How-to-Pass-a-URL-Filter-to-Publish-to-Web-Report-checking-...

 

Creating different reports is not possible, there are too many (thousands)

 

Thanks

16 REPLIES 16
cottrera
Post Prodigy
Post Prodigy

Hi , I am also stuggling to filter a publishn to web URL.  Does anyone know of any solutions?
thanks

Richard

Anonymous
Not applicable

this would be such a helpful addition. vote for this idea for this to be added. Vote for it and hopefully we can see this get integrated!

https://ideas.powerbi.com/ideas/idea/?ideaid=fba6791a-c1a9-eb11-89ee-0003ff452f24 

emilolbinado
Frequent Visitor

Very interested to know this as well.. Need this feature for a lot of use cases.

Hi All,

 

If you are looking to filter via the URL, then Publish to Web does not currently support this.

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


Hope this helps.

Cheers, Matt

@MattCalderwood then how do you explain the report of which I shared the URL? This report seems to be a "publish to web" report...

Thanks,

Koen

I will do a quick test later on, with one of my own reports to see if I can work out what is going on.

Hmmmm... I hadn't picked up on the querystring part of those 2 URL's.
I had checked the documentation and taken it at face value.

 

My assumption was that the 2 links differed and were generated with different 'defaults' set on the report at the time of generation.

Apologies for not being more thorough before responding @KJanssens .

 

I would have said that the documentation must be out of date... but it was last updated 4 days ago.

Hi @KJanssens  Just had another look at the content of that report.

The author has used a number of custom visuals, and it looks like one of them might be responsible for setting a filter on the country.

Taking a look at the code now.... but I am guessing that this is how it has been done.

The custom visual could get at the URL of the report - and apply filters once rendered.
Still need to confirm that this is what is happening, but it would make sense and is a clever workaround for the limitation.

@MattCalderwood thanks for further investigating it!

I wonder, how can you see the code of that report? Is such a "publish to web" report available to download and reverse engineer?

Thanks,

Koen

@KJanssensI have some experience in building custom visuals - mostly for internal use with the company I currently work for.

The HTML markup that the rendered report produces contains mutliple IFrames.
Native visuals are rendered directly within the markup - custom visuals are loaded within IFrames to effectively 'sandbox' them from the rest of the report. This stops custom visuals from doing things that they shouldn't be allowed to do - but in the example you shared... getting access to the browsers URL is fairly trivial.

Custom visuals can be built to apply their own filtering/highlighting to elements within the report. So the more I think about this, the more I think that this is the only way to achieve this.

I think I might have a go at knocking up a generic filter visual that can run this scenario. Could be useful to lots of people have the same requirement to filter on publish-to-web embedded reports.

Anonymous
Not applicable

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

Did anyone found out how to achieve the filtering (in this case on country) as in the below link (on a Published To Web (public) report)?

For France:
https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyO...

The same for Belgium:

https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyO...

 

Did anyone found out how to achieve the filtering?? 

Anonymous
Not applicable

Hi, could pls help me.

 

i have the same problem as @mlarab .

 

i have report 

 

Diccident_0-1623327265280.png

and i can filter him inside POwer Bi pro 

 

Diccident_1-1623327335524.png

 

but after publish in web, i can con filtered him (( everything do not work 

measure of report

measure of page 

direct filter on column....

 

could you help me pls 

 

https://app.powerbi.com/view?r=eyJrIjoiM2IxYjE5MmQtNWRkZC00YjJlLTg4MDgtM2VlNWQ1YmFjNTI5IiwidCI6IjIwO...

 

 

Hi,

 

Any solutions and advice how filtering on web published report is done?

 

We are struggling a bit here.

 

Thanks!

Hey,

Did you get any reply in this, how report filter is working in published to web url?

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors