Pass parameter value in URL query string?

[Dave82]

Hi,

I have a report which has several metric measurements to choose from.  What I want are unique urls that will display a desired measurement from my dropdown slicer when the report loads.

I saw this article but I think it is for paginated reports only: 

https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-url-pass-parameters

So ideally something like this:

https://app.powerbi.com/groups/xxx-yyy-zzzz/reports/yyyy-8edda9483589/ReportSection?rp:metricName=Do...

https://app.powerbi.com/groups/xxx-yyy-zzzz/reports/yyyy-8edda9483589/ReportSection?rp:metricName=Re...

But that doesn't seem to work, I created a metricName parameter but the value doesn't get updated when I use one of the above urls.

I looked at this as well: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

I tried to use the url filter to filter down the table used to populate my slicer but it doesn't seem to work (all values in the table are still listed):

https://app.powerbi.com/groups/ xxx-yyy-zzzz/reports/yyyy-8edda9483589/ReportSection?filter=MeasuresTable/MeasureName  eq 'Downtime'

Is there no way to pass a simple parameter value through the url and read it in the report?

[zafarpatel]

did you get solution for this ?

[JirkaZ]

You could do the URL filters when using fields (not measures like you want to do). 

But there are approaches to achieve the switching of displayed metric types. 

It typically consists of a slicer (based on a disconnected table) and a "universal" measure that uses a SWITCH statement to decide which measures to display.

[Dave82]

That is what I am doing already, I am using a global measure with a switch to do the current measure selection, the problem is I lack the knowledge of how/when to tell the report which measure to switch to when the report loads.

I am migrating a bunch of reports from Spotfire, and in Spotfire you could save bookmarks (which I know you can do in PBI as well) and then you could reference the url via the bookmark id like https://spotfire.mydomain.com/report/Papermaking?bookmarkid=someguid and it would load the specific view with all the settings saved.  The goal here is the user can open the report and not have to do a bunch of manual filter selection (they need things made easy lol).  I really don't want to have to make 100 separate pbix report files, I wanted it to be as dynamic as possible, since we will have like 20 different measures that hit the same data table.

I guess I naively assumed PBI was just as mature as Spotfire.

[JirkaZ]

But you can create bookmarks and copy the url with the bookmark guid too.

[Dave82]

Sorry how do you do this?  In Spotfire you can right click on the bookmark and click generate URL but I don't see any option in PBI desktop

[JirkaZ · Accepted solution]

Open the report and switch to the bookmark of choice and copy the URL

[Dave82]

Sorry for the delayed response.  I didn't realize you needed to publish the report, open it up online, then click the bookmark to alter the url.  In Spotfire, you can right click on the bookmark in the thick client and click get url.