I've hada considerable success using XRM Toolbox "Power Query (M) Builder" to load Dynamics CRM views into Power BI. This failure is the first I've experienced.
The error message is:
Expression.Error: The field '_from_value@OData.Community.Display.V1.FormattedValue' already exists in the record.
Details:
Name=_from_value@OData.Community.Display.V1.FormattedValue
Value=[View:/cfs-file/__key/communityserver-discussions-components-files/117/Power-Query_2D00_-generated.txt]
The specific statement in error is:
= Table.ExpandRecordColumn(#"Converted to Table", "Column1",
{
"subject",
"_regardingobjectid_value",
"_regardingobjectid_value@OData.Community.Display.V1.FormattedValue",
"activityid",
"prioritycode",
"prioritycode@OData.Community.Display.V1.FormattedValue",
"actualend@OData.Community.Display.V1.FormattedValue",
"_from_value@OData.Community.Display.V1.FormattedValue",
"_from_value",
"_from_value@OData.Community.Display.V1.FormattedValue",
"createdon@OData.Community.Display.V1.FormattedValue",
"ac.companyname",
"ac.ownerid",
"ac.ownerid@Microsoft.Dynamics.CRM.lookuplogicalname",
"ac.ownerid@OData.Community.Display.V1.FormattedValue",
"ac.new_manufacturerid",
"ac.new_manufacturerid@OData.Community.Display.V1.FormattedValue",
"ac.new_machinemodelid",
"ac.new_machinemodelid@OData.Community.Display.V1.FormattedValue"
},
{
"subject",
"_regardingobjectid_value",
"_regardingobjectid_value@OData.Community.Display.V1.FormattedValue",
"activityid",
"prioritycode",
"prioritycode@OData.Community.Display.V1.FormattedValue",
"actualend@OData.Community.Display.V1.FormattedValue",
"_from_value@OData.Community.Display.V1.FormattedValue",
"_from_value",
"_from_value@OData.Community.Display.V1.FormattedValue",
"createdon@OData.Community.Display.V1.FormattedValue",
"ac.companyname",
"ac.ownerid",
"ac.ownerid@Microsoft.Dynamics.CRM.lookuplogicalname",
"ac.ownerid@OData.Community.Display.V1.FormattedValue",
"ac.new_manufacturerid",
"ac.new_manufacturerid@OData.Community.Display.V1.FormattedValue",
"ac.new_machinemodelid",
"ac.new_machinemodelid@OData.Community.Display.V1.FormattedValue"
})
Hi,
The line 104 and 102 of your query extract the same field name: _from_value@OData.Community.Display.V1.FormattedValue.
{"_from_value@OData.Community.Display.V1.FormattedValue", "fromhidden"},
{"_from_value", "From (from)"},
{"_from_value@OData.Community.Display.V1.FormattedValue", "From"},
Could you remove one and retry ?