Forum Discussion
empty table values
Hi all ,
here in power query editor iam able to see the table values but when i view it in the table view my table is empty please let me know how can i resolve this
Thanks and Regards
I think you have some empty rows and in table view they've jumped up to the top. If you scroll down is there any data further down? Or if you select one of the filters in the column headers, try unselecting blanks to see if this is the case.
If you have got blank rows, go into Power Query and select "Remove Blanks" on the table in question.
5 Replies
I think you have some empty rows and in table view they've jumped up to the top. If you scroll down is there any data further down? Or if you select one of the filters in the column headers, try unselecting blanks to see if this is the case.
If you have got blank rows, go into Power Query and select "Remove Blanks" on the table in question.
hi AlexanderPrime i had some empty rows at the top but while removing the blank rows from power query editor iam getting this error
Hi,
it seems the null rows are shown at the top of your column.
As I see in the print screen that you shared, the particular column has 7 distinct value.
Scroll down or click on icon on top of the column, so you could see the value in that column
Appreciate your Kudos
