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
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?

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

      If you are in EST, and you are doing this at 10AM, then the timezone difference isn't big enough to make a difference.

       

      I would need to understand your scenario a bit better to diagnonsis this. For example, if the files were protected by an account, and the system was set up to only return results that were avialable to the account, then a difference in the credentials could result in no data.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        OK, In that case, please let me know the information you required to perform diagnosis in this case.

        • I am using Power BI Desktop and having 3 data sets files manually loaded in my organization One Drive and my source will be like this

         

        • 2 files are .CSV format that was replaced on daily basis by morning 9.30 AM EST hours. These 2 files will have updated employee training status, you can expect the rows count increased daily and few column values will be changed in the existing status. Ex - Training status of the employee will be converted from Not completed to completed and new enrollments will be added
        • 3rd file is an excel file with country, region and location values. linked with 2 CSV files to generate location values
        • The Data source settings are maintained as "Organizational" in the Privacy level and credentials for are maintained as Organizational account

        Please let me know if you require any other information in this regards.