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

[mho131197]

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!

[v-yanjiang-msft]

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.