OData Feed - Key matched more than one row

Hi avdw 

There is a setting "Automatic detection of column data type and headers" in Power Query.

This setting is specifically for unstructured sources. It helps you by automatically inspecting and detecting column types and headers based on the first 200 rows of your table. When this setting is enabled, Power Query automatically adds two steps to your query:

• Promote column headers: Promotes the first row of the table to be the column header.
• Changed type: Converts the values from the Any data type to a data type based on the inspection of the values from each column.

By default, this setting is enabled. According to your description, maybe this problem is caused by automatic detection of column data type. Automatically detected data type cause errors in data structure recognition.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.