Passing parameters to the report URL

[MP_123]

hi, is it possible to pass paramters to the report URL?

for example to directly slice on October .. 

is it possible?

thanks!

[Seth_C_Bauer]

@MP_123 Nothing I know of allows us to do this. I have the same request thinking about furthur future integration. Here is a current idea to vote up. It looks like this one has the most votes, and the comments align with this request.

[MP_123]

actually i don't understand why this idea is what i asked maybe i'm wrong.

i want to give users direct link to the report, with the filters that i want them to see

i saw something with

&?filter eq 'Month'

but it doesn't work for me and i don't know if this is the right syntax or when can i find it.

thanks!

[v-ljerr-msft]

Hi @MP_123,

I just tested it on my side, and I can still pass parameter to the report URL. The syntax should like below.

ReportURL?filter=tableName/columnName eq 'value'

Regards

[kishoresahu]

http://localhost:83/reports/powerbi/Opportunity%20By%20Count%20and%20Amount?filter=FactOpportunity/Nature eq 'adhoc'

I am Trying to solution above url In Report server but Filter Not working

[gilbertocrespo]

I guess this link you could solve your questions, my friend:

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/

It was very useful to me.

[Seth_C_Bauer · Accepted solution]

@MP_123 Wow, yeah...  I was a little off here. I was thinking SSRS integration with Power BI... Most likely a leftover conversation in my head from this week. - Sorry!

In the Service the report slicers/filters will stay as the selected filters if you save the report with those selections.

I'm not 100% on whether or not this is achiveable in the Service... I know you can pass in filters to an Embedded report. You can find a quick sample outlined by Adam Saxton in his video he just released yesterday - here

He gives you access to a sample where you can set filters and pass them in to the report, and the code to go along with it.

Hopefully this answer is more applicable 🙂