Forum Discussion

alexleyva's avatar
alexleyva
New Member
5 years ago
Solved

URL date parameter for Paginated Reports

I have a report that I has a date parameter.  I want to default it to today's date with the option for the user to change it to any date after it renders today's info.  I can hard code a date like so...
Paginated Reports
power bi
  • pabeader's avatar
    pabeader
    5 years ago

    Could you set a default value expression of =Today() in the parameter?

alexleyva's avatar
alexleyva
New Member
5 years ago

I do have a default value expresion that gets set when I manually select a value for another parameter.  If I try to add both parameters to the URL, I can only hardcode the date.  Will not allow me to add something like "Today()"  Here is an URL that works:

https://app.powerbigov.us/groups/{Blah}/rdlreports/{Blah} &rp:courthouse=-2&rp:courtcode=BUR%20&rp:courtcode=NCA%20&rp:courtstartdate=2021-03-16

 

This one does not work:

https://app.powerbigov.us/groups/{Blah}/rdlreports/{Blah} &rp:courthouse=-2&rp:courtcode=BUR%20

or

https://app.powerbigov.us/groups/{Blah}/rdlreports/{Blah} &rp:courthouse=-2&rp:courtcode=BUR%20&rp:courtstartdate=Today()

pabeader's avatar
pabeader
Post Patron
5 years ago

Why are you trying to send it in the URL rather then doing it in the report design?