Power BI Service Refresh not reflecting Today’s Date

[esam]

Hi Fam,

So in power query I have created a column in some of my table as rundate with date.localnow()

so it shows the today's date 

and then I added those columns in my table visual report but even after successfully refreshing the semantic model in power bi service the Rundate is not getting updated in my report

i have to manually go into power bi desktop or query and refresh the dataset then only it is reflecting.

please help with solution 

[Anonymous]

Hi, @esam 

Maybe you can try to create a custom function in Power Query to force the date to be updated. For example:

let
GetCurrentDate = () => DateTime.LocalNow()
in
GetCurrentDate

You can also check the following links:

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

How to Add Refresh Date in Power BI - Zebra BI

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Remember that Power BI Service runs on UTC.

[esam]

Even if power bi service runs on UTC it should reflect if not 6th December atleast 5th December but it seems my report data is stuck I mean the Rundate column is stuck to the date on which I have refreshed the report in power bi desktop

 Even though my refreshes are showing as successful in power bi this is not getting updated.