I see lots of questions about parameters but I'm struggling to identify the right solution.
I have a project to publish some public data to the web for each of 184 countries.
I can build the report I want for a single country, and I can publish to web to share publicly. Great.
Now I want to do the same for the next 183 countries. Obviously it makes sense to use the same report and just pass in some parameter somehow to the url or some api which I can use in my report to filter results.
The documentation says I can't pass a paremeter in on the url when sharing publicly (publish to web).
But surely there is some way - I do not need to make 183 copies of the same report changing just one parameter and publish them all to web to get 184 different urls?
Using a slicer inside the report is not an option as the report itself needs to be shown in the context of some other information outside power bi.
I'm sure there must be a simple solution and I would be graetful if someone could point me in the right direction.
Unfortunately, there is not much you can do when it comes to publish to web as its basically generates an HTML link
But you have 2 alternatives:
Hope it helps.
Thanks for your response.
1. This is information we want to publish openly - obviously requiring power bi licenses isn't feasible.
2. Drillthrough is not really an option for the same reason slicers aren't - there is lots of other contextual information outside the power bi report so it would be very confusing to allow country selection / change inside the report.
I find it hard to believe that there is really no way to pass some kind of data through to a report at display time, either via the url or some api? This seems like a really basic requirement.