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
You might simply be seeing this red-and-white dotted bar because the file you use as a data source is open in another software, for example in Excel.
Close that file and refresh the preview in PowerBI, the line will change back to green.