Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data changes are not updating in Data sets when using Scheduled Refresh options.

Data changes are not updating in Data sets when using Scheduled Refresh options.   Source data are connected with 3 CSV files connected to Power BI from SharePoint and 2 files will have data update...
Need Help
artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Maybe it is a timezone issue? The online refresh happens in UTC, while yours may be in a different timezone. As a result, when refreshing online, the service may be requesting data for a future date.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Artemus,

     

    I am scheduling the job for 10.00 AM EST or 5.00 UST. The files are generally dropped by 09.00 AM EST. Also, the refresh never made any updates for 2 days. Not sure, If I am missing anything beyond that

    • artemus's avatar
      artemus
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      The important question is what time zone are you in?

       

      If you are in UST, then your 5:00 your time is 23:00 UTC on the previous day. If you then try to get data for the date of that time, you will locally try to get the current day, but when refreshing online, you will try and get the previous day.

       

      See if doing a refresh 2 hours later helps.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        btw, What is UST time zone. I work in EST Time zone and it been scheduled to for 10.00 AM EST Hours and I drop my file at 9.00 AM EST hours.

         

        Can I schedule the job for 12.00 PM EST and Drop the files for 9.00 AM EST. So, I will have more than 3 hours of time?