How to find which table has an error

[qmestu]

Hi,

In one of my dashboards i have a set of tables that have a web source (a JSON file). All these tables individually seem to work fine, but when i merge them together (they have the same fields and structure) an error occurs, likely because one of those JSON files is not returning values. Is there a way to find which one of the tables is doing this? I've tried using fiddler to debug the web querys getting processed in the background but no luck.

Thanks.

[v-saisrao-msft]

Hi @qmestu ,

We haven’t heard back from you regarding which table has error. If it has been resolved, please mark the helpful response as the solution to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @qmestu,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @qmestu,
I wanted to check if you had the opportunity to review the information provided by @burakkaragoz . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[burakkaragoz · Accepted solution]

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