Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Data missing

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! 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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. 

7 Replies

  • zenisekd's avatar
    zenisekd
    Super User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

    • zenisekd's avatar
      zenisekd
      Super User
      2 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

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