Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

"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 s...
Need Help
  • Geradav's avatar
    Geradav
    6 years ago

    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

     

     

Geradav's avatar
Geradav
Icon for Responsive Resident rankResponsive Resident
6 years ago

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

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Now I understand! It's to help find errors, so that I can remove them. Awesome! 

 

Thank you so much!