Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Table.SelectRowsWithErrors gives "This table is empty"

I have aata imported from CSV and manipulated so I am very familiar with errors and the GUI always lets me view errors which makes it easy to troubleshoot.  But this has me stumped. Refresh on my ta...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

This phenomenon typically happens when your columns contain data that doesn't match the data type of the column. This is allowed in Power Query, but not when the data is loaded.

An example would be numbers with fractions, while your column's data type is whole number.

 

Finding the errors: visually check if the actual data in each column matches the data type of the column.

Solving the errors: make sure the data types of the columns match the data types of the values in the columns. 

 

In addtion, I would suggest you to refer to this thread: error message after building query returns zero ro...

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.