Data missing

[Anonymous]

I import the same Excel file regularly with the same data which I extract from an online source. However, for some reason the data as from a certain month is no longer displayed in my dashboard. See below. The likes for these entries are not supposed to be 0. The rows that show 0 are the ones after August 2023. Before August I did not have any issues. Nothing changed to the column type, etc.  The data for the two other columns are displayed correctly. Any idea what could be the cause? Thanks! 

[Anonymous]

Yes, I'm 100% certain. From August, PowerBI just stopped reading the data in this particular column. 

[zenisekd]

Is there a chance you shared the dataset (perhaps just the particular date and like column)?

[Anonymous]

I misunderstood earlier. I can not share unfortunately because it's company data. I have double checked again, and the data in the columns (Shares, Impressions, Likes) is exactly the same. 

[Anonymous · Accepted solution]

Hi! The problem has been fixed! Upon checking the Excel sheet again, I noticed that the data in the columns starting from a certain date was not formatted as a table. After changing this, all the data is now visible. Thanks for the help. 

[Anonymous]

Hi. Thanks for trying to figur this out. It's just a basic excel sheet. I did not share any of the data. 

[zenisekd]

I meant, if you can share with me the data, so I can test it.

[zenisekd]

Are you 100% sure your data is in the excel file for those months? My guess is they are missing in the source.