Power Bi report after refresh not reflecting the latest date.

[esam]

Spoiler

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 ,

Based on the testing, create a column to show local now tiem. After refreshing the semantic model, try to refresh the page.

But, power bi service datetime default set to UTC.

Best Regards,

Wisdom Wu

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

[powerbiexpert22]

Hi @esam , you will have to set up refresh in power bi service to make it work

[esam]

Hi @powerbiexpert22 my refresh is set 

does it only reflect in schedule refresh or refresh now does the same ? 

[powerbiexpert22]

Hi @esam ,

power bi service doesn’t automatically recalculate or refresh those types of dynamic columns like  rundate () after the initial dataset refresh , refresh now happens in desktop which recognize the rundate()

[esam]

@powerbiexpert22  So if I run the refresh in power bi service the Rundate will not change until and unless I open the pbix file and refresh that file in power bi desktop ? 
is that what you're saying ? 

[powerbiexpert22]

Hi @esam 

no, i meant ..try to set up schedule in power bi service and see whether it is showing expected results

[Kaviraj11]

Try this  and adjust your timezone accordingly if you are in region with time change else go with below code:

let

    CurrentDateTime = DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -5),

    AdjustedDateTime = if DateTimeZone.ToLocal(CurrentDateTime) <> DateTimeZone.ToLocal(DateTimeZone.SwitchZone(CurrentDateTime, -4)) then DateTimeZone.SwitchZone(CurrentDateTime, -4) else CurrentDateTime

in

    AdjustedDateTime

---------------------------------------------------------------

DateTime.LocalNow()+#duration(0,-4,0,0) 

[esam]

Hi Kaviraj, 

the thing is the data model should reflect the next day the correct date but I'm not getting that it seems even after refreshes power bi is not reflecting though the refreshes are successful 

 this is even after multiple refreshes