Forum Discussion
Error We cannot convert the value "Parent1" to type Function.
Change
each Record.Field(_,Parent)=nullto
each Record.Field(_,"Parent")=null
Super UserChange
each Record.Field(_,Parent)=nullto
each Record.Field(_,"Parent")=null
thank you lbendlin
After changing as per your recommendation, the following error message appears
An error occurred in the ‘’ query. Expression.Error: The field 'Parent' of the record wasn't found.
Details:
Parent1=A1
Child1=B1
Qty=1
and if I change the column name "Parent1" to "Parent", the error is:
An error occurred in the ‘’ query. Expression.Error: We cannot convert the value "Parent" to type Function.
Details:
Value=Parent
Type=[Type]
- lbendlin
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523