Forum Discussion
missing columns not returned when iterate through web service
I'm calling a SOAP API in XML to pull down a report into Power Query. The query iterates through a list of locations stored in a manual table. The problem I have is when the location doesn't have a v...
cleon169,
I note that the #"Changed Type" step metions the 'MoveIn' column. When your table doesn't have this column, the above error will throw. Please delete the "Change Type" step under "APPLED STEPS" in Query Editor of Power BI Desktop.
Regards,
Lydia