Table loaded to model with errors but records exist on the table

[some1else]

Hello guys,

In Power Query I have set up the following queries:

query1, query2 and query3 load historical data from Excel file (load disabled);

query 4 loads data from an API (load disabled);

query 5 loads more data from the API with a common ID record (load disabled);

query 6 combines all previous queries into one final that loads into the model.

Query 6 loads with errors but when comparing those errors with the actual query 6 table, they all exist and are equal, no differences!

Any idea what could be causing those errors to pop up?

[v-yalanwu-msft]

Hi, @some1else ;

Can you share the following error message? I can't judge the reason for the information provided, and finally provide the following screenshots and so on.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[some1else]

Sorry for the late reply. There's no popup with a specific error message, just the general popup saying the X rows were loaded with Y errors.
I can try to activate logs to check if anything comes up