Forum Discussion

pclewisnz's avatar
pclewisnz
New Member
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 table tells me there's 9039 errors (of 9039 rows).  OK so this is not uncommon if I am mishandling a null or datatype and it's usually a simple fix.
My go to is a simple search to show me the error column(s) for the first few rows to save time.  To save confusion here I show the line of code that produces 0 rows 

 

let
    Source = Interactions,
     KeptErrors = Table.SelectRowsWithErrors(Source, Table.ColumnNames(Source))
in
    KeptErrors

 

 

Clicking on View Errors results in no activity so I manually created the table above to help me figure it out - not knowing if the problem is the tool mis-reporting errors or if Table.SelectRowsWithErrors is just wrong.  I assume it'll be somewhere in between where the refresh data thinks something is an error but SelectRowsWithErrors doesn't.

Of course when I scroll along every column looking for any sign of Error or NaN or the like I find nothing.

I am sure this will be a trick/tip for newbies like me if someone has the time to point me to where I'm going wrong I'd appreciate it greatly.

 

 

2 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional

    Can you go to view tab, check Column Profile and see what does it show here against all columns?

  • Hi pclewisnz ,

    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.