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!
TomMartens
Super User
Super UserHey somecallmedave ,
I understand that you see data from 2018 in Power Query,
You do not see data from 2018 in the Report view if you add the date column to any slicer, after you have refreshed the data.
Check the following:
- Is there a step in the PowerQuery query that filters out dates from 2018
- Do you see dates from 2018 in the data view, after you have refreshed the data
- Are there page level filters that prevent the use of 2018 data
- Make sure there are no hidden slicers on the page, sometimes this happens if one is experimenting with slicer synchronization and hidden slicers. Use the selection view to make sure there is no hidden slicer
Hopefully, this provides some new ideas
Tom