Forum Discussion
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 updated on daily basis. I have enabled a schedule to refresh the data and will be placing the csv files manually. Schedule status shows successfully completed but the updated changes are not reflecting in the dataset. Only Refresh done inside the POWER QUERY EDITOR, the changes are reflecting in the tables. What could be the problem
8 Replies
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.
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
How did you check whether the change has updated the dataset?Because, refresh does not automatically update the new data to reports on Power bi service, the change only reflect to the pined visuals in dashboard, maybe try manual refresh the report page on Power bi Service.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I created a table to identify the counts updated. My data visualizations are maintained based on daily status. Example - Today is October 08 2020. After the schedule refresh completes I manually validate and so far, You can see last updated values are till October 07 2020. That is something I manually refreshed
