cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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?

 

PBI Column Headers.png

1 ACCEPTED SOLUTION
artemus
Microsoft
Microsoft

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 

View solution in original post

5 REPLIES 5
guh950
Microsoft
Microsoft

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.

michellepace
Helper V
Helper V

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

artemus
Microsoft
Microsoft

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 

Is there a documentation which colour mean what? 

I saw now a few different colour variants but I don't know what it means. 

 

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors