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 ...
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. 

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. 

    • zenisekd's avatar
      zenisekd
      Super User
      2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      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.