Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.