Report URL issue in passing a DateTimevalue

[SuryaVee]

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

[v-piga-msft]

Hi @SuryaVee,

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

Sorry for any inconvenience!

Best Regards,

Cherry

[SuryaVee]

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 · Accepted solution]

Hi @SuryaVee,

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

[SuryaVee]

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