Forum Discussion

esam's avatar
esam
Frequent Visitor
1 year ago

Power BI Service Refresh not reflecting Today’s Date

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 

dataflow
Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    1 year ago

    Remember that Power BI Service runs on UTC.

    • esam's avatar
      esam
      Frequent Visitor
      1 year ago

      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.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.