

February 5, 2019

Hi
I created a table (namely table9) in a worksheet that is giving me a headache. Every time I try to filter, remove rows etc in Power Query Editor, it gives me Expression.Error: The key didn't match any rows in the table (screenshot attached).
When I check 'Source' in Power Query Editor, I see table9 listed under 'Item' along with other tables but it disappears ( The table is empty) when I click the table9. To get around it, I refresh the query then table9 reappear. Refresh is required every time adding a step in Power Query Editor. This is the only table that I am having a problem with and hope to find a way to fix it, please.
Thank you
LN


February 5, 2019

Hi Mynda,
What is confusing is that nothing has changed at all. The source data is created just once, nothing changed - file is closed. Table9 is listed in Power Query editor, then it disappears saying that the table is empty when I click it. Then I 'refresh', table9 comes back so I can filter rows, then try deleting rows etc, it disappears again then refresh once again, then table9 comes back. I have not touched the source data at all. This is the only table that I am having trouble with...
Thanks again,
LN
1 Guest(s)
