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!
If you could see 2018 data in data view in power bi desktop.
If possible, could you please share your sample pbix file for us to have a test, that will be a great help.
Regards,
Lin