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

Question

Hello guys,&nbsp;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.&nbsp;Query 6 loads with errors but when comparing those errors with the actual query 6 table, they all exist and are equal, no differences!&nbsp;Any idea what could be causing those errors to pop up?

v-yalanwu-msft · Answer

Hi,&nbsp;some1else&nbsp;;
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 WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

some1else · Answer

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

Forum Discussion

Related content

Error loading Power BI report

Getting Error Cannot load model

Sporadic Stored Procedure issue - not loading new records

Model loading error

Date Load errors