Forum Discussion
Scheduled Refresh Succeeds but Data Won't Update
spinachbisque How quickly are you checking the report after the dataset has said it has refreshed? The Dataset, Report and dashboard are seperate objects and are not all immediately refreshed after the dataset. It is in order. If the dataset refreshes, it is likely it will be 10-15 before the report, and then the Dashboard. You can also initiate a refresh in the report after the dataset.
If you know, and or tried the above, then this sounds like a bug or issue that you should raise in a support ticket or the issues page.
I'm going to add an additional potential scenario to this.
I had been on leave from work for the last few weeks and the dataset for my dashboard would NOT refresh. The automated refresh cycle ran without a failure the entire time, but the data itself was not updating. There are two datasets, both are CSV files. One CSV is a calendar for fiscal year date conversions among other things that remains the same, no worries there. The other is a dataset that updates daily that many users look to daily and are in need of accurately reported updates. Refreshing in the desktop version worked, but the dataset just would not update online at all.
That particular dataset is obtained daily through a Power Automate flow that results in a CSV being saved to One Drive. In going on leave, my employer's security department places a temporary password on everything and my data connections are Windows login based (currently awaiting a generic account to be created to provide for a continuous/uninterrupted solution during leaves or if I were to leave the company, etc.). In an effort to prevent downtime since my credentials would not be the same during my leave, I added another analyst who had taken over the datasets with their gateways.
Kinda sidetracking there, but upon my return, I took the datasets back over, reestablishing my gateways and connections with my new credentials. Upon checking the datasets, the daily refreshed file was "stuck" based on data of my last day of work prior to leave. I searched high and low for a solution to this and convinced myself that the connection was looking at the One Drive connection of my old credentials prior to my leave and adjusting the credentials did not resolve the issue whatsoever. Even establishing a new connection did not do the trick.
However, I watched this video here from Guy in a Cube, and this resolved my issue: https://www.youtube.com/watch?v=CYSMZxaXNLk
The CSV file I was using had a C: drive directory based on my One Drive connection. I went directly to One Drive, selected View Online, then opened the CSV file, went into the Info menu, copied the file path and replaced FileContents with WebContents and the associated file path. I then refreshed the desktop version, published it to the web and confirmed that the data is now showing the updated/correct information.