Forum Discussion
Solved
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.
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