Forum Discussion
Solved
Some Rows Not Accessible/Viewable When Filtering by Date/Time Column
Hello, One of our database tables has a date/time column that has dates going back to at least 2018 that can be seen in the Power Query Editor window (Figure 1). We noticed that data in rows ...
It is possible that some of the data in your table has been archived and your preview is showing an out of date snapshot of the data. Try refreshing the data connection and preview and seeing if the dates that can't be sliced or filtered are still there.
Cheers!
It is possible that some of the data in your table has been archived and your preview is showing an out of date snapshot of the data. Try refreshing the data connection and preview and seeing if the dates that can't be sliced or filtered are still there.
Cheers!
This seems to be exactly the issue! The old data was not there in preview this morning.