Forum Discussion
"This table is empty" - importing from excel (Kept Errors)
Hello, I'm a power bi noob, so any help is much appreciated. I read the other post that had a similar title, BUT that was to view the error or trace log. But I need to understand why my table isn't showing. This file was made by someone else, and I have inherited it. Please see below. I don't know what "Kept Errors" means, and neither does the entire internet either. I've been searching for an explaination of the function, but nothing. Please help me to figure out why the table is empty and how to fix it.
Hi Anonymous
From my experience, each time a query contains errors, Power Query automatically generates a query with the errors. This error query (called "error in ....") references the original query and filters it to the records that contain errors.
Once you have attended to those errors in the original query, this "error query" returns an empty query as there are no errors to show anymore, and it can be deleted.
Let us know if that helps in your case.
Regards
David
2 Replies
Hi Anonymous
From my experience, each time a query contains errors, Power Query automatically generates a query with the errors. This error query (called "error in ....") references the original query and filters it to the records that contain errors.
Once you have attended to those errors in the original query, this "error query" returns an empty query as there are no errors to show anymore, and it can be deleted.
Let us know if that helps in your case.
Regards
David