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 value should be prefixed with DateTime.

 

Can anyone please give me the syntax for the same?

 

I tried the below URL and it does not work,

"<ReportURL>?chromeless=1&filter=DestnReportTable/DestnTableColumn ge DATETIME '2018-09-27 9:52:00 AM'"

 

When I use the above URL, the destination report field does not get filtered based on the date given.

 

Need help.

 

Thanks

SuryaVee

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

4 Replies

  • 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

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    I have had a contact with PG and will update here if I get any information.

     

    Sorry for any inconvenience!

     

    Best Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Okay..

      Or is it possible to pass the value as String and make it available as a Text atleast in the destination report?

       

      What I'm trying to achieve is,

       

      My Source report is in Import mode and I need the Last refresh time of that Import mode dataset to be passed to the destination report (in Direct Query mode). This is because all the new records that are not yet refreshed in dataset will be highlighted in the destination report (Direct Query with Live data). 

       

      Is there any other way to get the Last refreshed time of Source dataset in my Destination report?

      Or is it possible to pass that as a string and have the value stored in a column so that i can use it for Conditional Formatting.

       

      Thanks

      SuryaVee

       

       

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        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