Forum Discussion
Power Query Editor Red/White striped bar
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
Hi Mike,
I purposefully "broke" my data connection and got this red-white dashed line in the effected Query. The line remained there until I fixed what I broke.
That is to say, in power query editor I was connecting to a table in my excel file named sales_2018. I then opened my excel file and change the table name to sales_hello. Once I clicked refresh in power query editor, the query "sales_2018" got that red-and-white candy line below it. Obviously an indication that something is broken. I had to click on the query, then choose "Navigation" in the applied steps, and click on my newly named table - sales_hello. After that the red and white candy stripe disappeared.
Cheers,
Michelle