cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: Report URL issue in passing a DateTimevalue

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'

report url filter.png

 

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

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Frequent Visitor

Re: Report URL issue in passing a DateTimevalue

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

Highlighted
Resident Rockstar
Resident Rockstar

Re: Report URL issue in passing a DateTimevalue

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Report URL issue in passing a DateTimevalue

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

 

 

Highlighted
Resident Rockstar
Resident Rockstar

Re: Report URL issue in passing a DateTimevalue

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'

report url filter.png

 

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

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors