Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Creating different reports is not possible, there are too many (thousands)
Thanks
Hi , I am also stuggling to filter a publishn to web URL. Does anyone know of any solutions?
thanks
Richard
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
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.
Hello @mlarab ,
Have you found the solution?
I know that you could do it but I do not how, see below an example:
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)?
The same for Belgium:
Did anyone found out how to achieve the filtering??
Hi, could pls help me.
i have the same problem as @mlarab .
i have report
and i can filter him inside POwer Bi pro
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
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
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |