Forum Discussion
Helper IITable loaded to model with errors but records exist on the table
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?
2 Replies
v-yalanwu-msftCommunity Support
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.
some1elseSorry 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