Forum Discussion

mho131197's avatar
mho131197
Regular Visitor
3 years ago

Power BI Advanced Editor Error-Expression.Error: The field 'records' of the record wasn't found.

Please help!!!

I am trying to write a block of code in power bi to bring data from an API URL link using id as a parameter but when I try to invoke custom function, it gives me error message "Expression.Error: The field 'records' of the record wasn't found." but it still provides me the data in each field just not as a list to expand. 

I included the error message and the block of code below. Thank you!

 

Need Help

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi mho131197 ,

    According to the error message, firstly please confirm the function name is correct and matches the query name you created. Then check if the function can work fine with a value from id column as parameter. If all is fine, would you like to provide the function here to help dive.

     

    Best regards,

    Community Support Team_yanjiang

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