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

Today() is showing incorrect value in portal

hi, I have a report with a table column defiend as follow:

ProcessDate = TODAY()
 
this is working perfectly fine in my report within Power BI Desktop.
However, after I published this report to Power Bi portal, for some odd reason, it always shows a static incorrect value.
What I meant "incorrect static value" is that, I uploaded the report to power bi portal on 10.24.19.
but when I checked this value on 10.24.19 and 10.25.19, it always shows the value of 10.21.19.
this issue only occur on report published to PowerBI portal, and doesn't repro on Power Bi Desktop.

Anyone else has the same experience? Any known fix or workaround?
 
Thanks
1 ACCEPTED SOLUTION

Accepted Solutions
lu8890 Frequent Visitor
Frequent Visitor

Re: Today() is showing incorrect value in portal

I am not sure why Today() is not working in the portal, but I just replaced it with Now() and it is now working as expected in both desktop and portal.

View solution in original post

1 REPLY 1
lu8890 Frequent Visitor
Frequent Visitor

Re: Today() is showing incorrect value in portal

I am not sure why Today() is not working in the portal, but I just replaced it with Now() and it is now working as expected in both desktop and portal.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,976)