Forum Discussion
Data shows in Power Query, but not in Data view
My source excel file has 30 rows and 10 columns. In the source file, all rows and columns are filled with data. However, when I connect to the file and build out a chart, some data is missing. In the...
I have run into a similar problem in the past with other sources. The data preview sometimes lies to you, so if you are getting different results it usually means there is a problem in the source that the query steps preview isn't picking up.
Since its the last row thats missing data, the issue will likely be present on that last row. Since you are only getting the first 7 columns, this indicates that the issue will be in the cell of that last row in the 8th column.
Open up your excel file, check that cell (and the ones either side) and see if there are any excel errors or funny characters.