topic Dynamic filtering in PBIRS in Report Server

Dynamic filtering in PBIRS

jonasr — Thu, 10 Aug 2017 13:24:51 GMT

Hi guys, quick question. Is it possible to use URL/dynamic filtering on reports stored within PBIRS?

If so, how do I specify which page of the report I want to access? Can you give me some generic example of the url string?

Let's say, I want to filter all visuals based on country. I tried something like this but it does not work (if I add ReportSection1 to the address simililarly as in PBI Service it gives me an error that such report does not exist):

http://myserver/Reports/powerbi/testPBI?filter=Customer/Country eq 'Australia'

Re: Dynamic filtering in PBIRS

Jon-Heide — Thu, 10 Aug 2017 22:16:30 GMT

Hi Jonasr - For paginated and mobile reports, yes. For PowerBI reports, not currently. Support for URL filters for PowerBI reports is a commonly reuqested feature and something we're looking into for an upcoming release.

Re: Dynamic filtering in PBIRS

jonasr — Fri, 11 Aug 2017 07:12:57 GMT

That's unfortunate. Hope it will be implemented soon.

Thank you

Re: Dynamic filtering in PBIRS

Grumelo — Thu, 28 Sep 2017 07:25:08 GMT

Is there at least a way to open a report on a specific page in PBIRS?

Not a filter parameter but a parameter to specify the page ?