Data doesn't pull through on refresh

[SunK]

Hi all,

I've made a dashboard which is drawing data from a sharepoint list. Everything was working fine up until two days ago where now the dashboard is not updating with the newest data and I can't figure out why. All of the tests seem to run fine, and the connections are still the same. The automatic refresh says its successful but it doesn't pull the data through. Manually refreshing is the same. I thought it might be the data size but I only currently have 228 rows? I've cleared my cache and restarted everything but I can't seem to figure out if I'm missing something obvious and just unclicked something. 

The sharepoint data comes from an MS form pulled automatically by a power automate flow. I can see the data in the sharepoint list but it's stopped reached the power bi dashboard.

[SunK · Accepted solution]

Managed to solve it, turns out the data was always there but it was not filtering the date correctly (so it would look like it hadnt refreshed). Had to add an hour to the date column and it's working normally. 

Thanks all.

[AnalyticPulse]

is there any change ine data structure of schema in sharepoint list?
if your power automate has failed or encountered an error then it may be faling to push data in dashboard on refresh>

Learn Power BI free:

https://analyticpulse.blogspot.com

Power BI : getting started

Dax functions

powerbi Visualisation