How to find which table has an error

Hi qmestu ,

A practical way to identify which specific table is causing the error is to load each JSON table individually in Power Query and check if they return data as expected. Even if the fields and structure match, sometimes a subtle issue (like a missing value, unexpected null, or a malformed record) in one file can cause problems when merging.

You can also try merging the tables in smaller groups (for example, two at a time) to help narrow down which one is problematic. This step-by-step approach usually helps pinpoint the file or table that’s returning errors.

Additionally, enabling error handling in Power Query (using the “Keep Errors” or “Remove Errors” options) might highlight the table or step where the error occurs. Checking the error details in Power Query can sometimes reveal more about what’s going wrong.

Hope this helps!
translation and formatting supported by AI