Dates show up in Power Query but not in Report view/Tables

[PeteyG]

Good Day

  We have had a report that was working fine for awhile and then all of a sudden just stopped working.  It has an Oracle back end pulling the data.  When in Power Query all the dates show up just fine but when we click "Close and Apply" and go to the report and tables only one of the dates show up.  Hundreds are missing and can not figure out why.  No filters on that we can see and we have rebuilt the report with no luck.  Someone else owns the back end data so not sure if they changed time settings to mess us up or something else.  If anyone has advice that would be greatly apprciated.  

[johnt75 · Accepted solution]

The years in the Power Query view are incorrectly formatted. They show as being in the year 0025, 0026 and 0027, not e.g. 2025. You'll need to add some Power Query steps to correct the dates.

[PeteyG]

Wow Thanks!  I can not believe I totally missed that.  Wonder why all of a sudden the dates got hosed.