Data shows up in my power query but not in my table

[Anonymous]

I have a super simple excel sheet I sourced. Lists a date, a person, and two values. The dates go from March to today. In power query, it shows all the dates and all the values from March through today, which is what I need. When I go and view it as a table, it only shows June through August. When I try to create a visual, it will only let me work with data from June through August. I've refreshed, I actually deleted everything and reloaded it, same thing. It won't show any of the other dates. There's no blanks, there's no difference in formatting, there is no reason for the data to show up in the query but not in the table. I'm very confused.

[v-xiaoyan-msft]

Hi @Anonymous ,

Have you solved your problem?
If not, please provide us with sample data that does not contain sensitive information,as edhans mentioned above.

How to provide sample data in the Power BI Forum 

Hope it helps,

Community Support Team _ Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

Can you share the PBIX file and source Excel file via Dropbox or OneDrive? No confidential info. There is some formatting or data difference, but I have to see the source data to work troubleshoot. This is not a bug in Power Query. It is an issue with your data.

Ensure your dates are true dates with no spaces, no hidden characters (ASCII code 160 creeps into data posted from the web for example) and in date format, not text format.

[Anonymous]

Oh I'm sure it is, I just can't figure out what it could be. I checked that the dates were formatted as dates, etc. What I don't understand is if everything shows up fine in power query....then why wouldn't it show up correctly as a table? Shouldn't the table have all the data that's in the power query? I'll get everything put onto drop box as soon as I can.