Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Report URL issue in passing a DateTimevalue

Hi Team, I'm trying to pass a datetime value from one report to another report using Report URL as Hyperlink. From the Report URL filters documentation, i came to know that for DateTime type the va...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    By my confirmed and testing, you could refer to the url parameter for datetime type below.

     

    URL?filter=Table/Date gt datetime'2018-09-27T09:55:00'

     

    You also could have a test with my test sample file.

     

    Best Regards,

    Cherry

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Have anyone tried passing DateTime value in Report URL?

From the documentation I see,

Add Power BI report parameters using the url - Power BI | Microsoft Docs

  • Dates and times must be enclosed with single quotes and preceded by the word DateTime

But it is not working for me , &filter=DestnReportTable/DestnTableColumn ge DateTime'2018-09-27 9:52:00 AM'"

 

Please correct me if I'm missing anything here.

 

Thanks

SuryaVee