Share via

Power Query Says column is 100% empty but its NOT

Sahlberg, Ian 1 Reputation point
2021-10-06T21:08:50.123+00:00

I have a column of depth values and nulls. They are decimal values (1.2, 5.6 etc). For some reason Power Query is not recognizing the data and saying the column is 100% empty (0% valid, 0% Error). I changed data type to decimal and that didn't help. If I filter on a value it recognizes the data but when I remove the filter the column goes back to 100% empty. Any ideas how to fix this issue?

thanks!

Community Center | Not monitored
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sahlberg, Ian 1 Reputation point
    2021-10-06T21:23:11.343+00:00

    Never mind, it seems that this issue isn't actually an issue, just misleading. I thought it was causing other problems but it seems to have fixed itself. I think since it is only looking at first 1,000 rows or so it shows as 100% empty since those rows ARE empty.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.