Data Format Error

Question

Hi There,&nbsp;I am trying to do data transfromation in Power Query where i am merging my table using Merge as a new . I am using dataflows as my input source in which i have imported 7 tables and i am doing Merge Query to create new table.I developed two new query using Merge Query and when i did Merge with one of my table "Table 1" with Table 2 i am getting below error when i expanded the column.&nbsp;Please see below sample of my data :&nbsp;Data Source- DataFlows&nbsp;Can anyone help me in resloving this error. ?&nbsp;Thanks,Ashamitchandak&nbsp;Ashish_Mathur&nbsp;&nbsp;&nbsp;

anonymous · Answer

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

wini_r · Answer

Hi Anonymous,&nbsp;You may want to check this thread and see if this helps:https://community.fabric.microsoft.com/t5/Service/DataFlow-Refresh-Error-and-Fix-for-added-Fields-in-Dynamics-365/m-p/615147&nbsp;

omid_motamedise · Answer

Can you share your M code here?

anonymous · Answer

Hi&nbsp;Omid_Motamedise&nbsp;&nbsp;Please see below :&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;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 .&nbsp;As per my kunderstanding&nbsp; 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&nbsp; which have exact same column and table names .&nbsp;Any other suggestion if you have?&nbsp;Thanks,Ash

Forum Discussion

Data Format Error

8 Replies

Related content

Data Refresh Errors

Data Format Error in Powerbi Service

Dynamic Formatting Error

Data Format Error

Data Format Error Details: _______