Forum Discussion

ruiz07s's avatar
ruiz07s
Frequent Visitor
3 years ago
Solved

Scheduled Refresh not updating with latest data despite refresh completing sucessfully

Hi everyone, long-time Power BI user. I have a Data Flow which connects to SQL Server with Gateway. This Data Flow is setup with Scheduled Refresh which successfully completes each morning. The issue...
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , ruiz07s 

    According to your description, your dataset is connected to your Dataflow, and you configured your dataset refresh correctly an hour after the DataFlow refresh was completed. And the dataset refresh was successful.
    Under normal circumstances, this should not be a problem. First of all, you need to check if your dataflow has new data generated, you can enter your dataflow after your dataflow has been successfully refreshed to see if new data has been generated.

    Secondly, can you check if some functions that generate today's date are used in your dataset? Because scheduled refresh in Power BI Service is using the UTC+0 time zone. If so, you can connect to your dataflow directly using the Dataset, then publish and refresh it to see if the refreshed data is the latest data.

    Finally, you need to check if refresh for that query is enabled in your Power Query.

    For more information, you can refer to :
    Managing query refresh - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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