cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lu8890
New Member

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
lu8890
New Member

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
New Member

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.