Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Solved

Passing parameters to the report URL

hi, is it possible to pass paramters to the report URL? for example to directly slice on October ..    is it possible?   thanks!
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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 :)

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

actually i don't understand why this idea is what i asked :smileyfrustrated: 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's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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.:smileyhappy:

ReportURL?filter=tableName/columnName eq 'value'

 

Regards