Forum Discussion
Data Format Error
Hi Anonymous ,
According to your description, the error message “DataFormatError: There were more columns in the result than expected” is usually caused by a mismatch between the merged table structure and the expected format. First of all, you need to make sure that the column names and order in both tables match exactly. And verify that the data types of the columns to be merged are compatible. Because your data source is derived from a data stream, you also need to make sure that the structure (column names and data types) of each table imported in DataFlows matches the structure you expect in Power Query. You also need to have the data in DataFlows successfully refreshed and up-to-date for all tables.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
You mentioned all the column name and order in both table shoudl be similar however i am trying to do Merge as new querty with Left Outer join with Table 1 on Table 2 where i am keeping all the columns from Table 1 . As per my kunderstanding in Append Query we should have Same column name and order will be same.
Secondly i have verified data format and my dataflow is being up to date and still i am facing this issue.
So i have changed my dataflow pervioulsy i was using different Dataflow-Dev and not i changed my DATAFLOW- test which have exact same column and table names .
Any other suggestion if you have?
Thanks,
Ash