empty table values

[Tarunika]

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

[MahyarTF]

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

[AlexanderPrime · Accepted solution]

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. 

[Tarunika]

hi @AlexanderPrime i had some empty rows at the top but while removing the blank rows from power query editor iam getting this error

[AlexanderPrime]

It sounds like one of your number columns may have an invalid character hiding in it (like a letter or a comma) 

I would check in Power Query to see which column contains it and amending it where possible. One way to help find is to use the Column Quality View in Power Query. Screenshot below for where to enable this 

This will give you a breakdown over every column if the data is valid, empty or has an error and should help you find where the data isn't translating into a number. 

[MahyarTF]

Follow this link :

https://www.cloudfronts.com/blog/power-bi/how-to-solve-ole-db-or-odbc-errors-in-powerbi/