Missing Data

[user900]

I pulled in 4 data files from my SharePoint Online folder.  Each file contains about 10,000 rows of data.  One of the data files return blanks in the Status field, however when I look at the source, this field is populated.   The other three data files populate correctly.   I read about buffering the table but thast did not seem to work.

Any suggestions?  

[rubayatyasmin · Accepted solution]

Hi @user900 

Check for the possible reasons that might cause the missing data issue. 

*Ensure "Status" column data types are consistent.

*Check SharePoint views for filters or item limits.

* If using Power BI or Excel, refresh your data.

*Re-establish your data connection.