Forum Discussion
Power Query Editor Red/White striped bar
I am using the Power Query Editor to pull in data from an excel file stored on sharepoint. I noticed there is a red and white striped bar below some of my coulmn headers. What does this bar mean? ...
It means errors were detected in some rows. Note that this takes a bit to update and may refer to a previous iteration you did.
Similarly blue means data, while black means empty/null
I got this same issue twice. Once from mismatched datatypes in the column, and another time when I had queried too many rows from an excel file and the file kept crashing. In both instances, investigating the issue in greater detail helped me figure it out, although this issues isn't always going to tell you why its occurring.