Call Rest API from Power Bi / Power Query

[Janne1]

Dear all,

I am facing the issue of the following error code:

'An error occurred in the " query.Expression.Error: The field 'XXX' of the record was not found.'

and this is the code (from this website: https://powerplatformtrainings.com/2022/07/20/call-rest-apis-from-power-bi-power-query/)

How can i get rid of the error code and continue building my Rest API connection with Power Bi.

Please help, Thxx

Janne1

[v-cgao-msft]

Hi @Janne1 ,

The error message you’re seeing, , typically occurs when Power Query tries to access a field in a record that doesn’t exist. To fix this issue, you need to ensure that the fields you’re trying to access do exist in the data you’re working with.
Please go to the Data step to check if the field [Result] exists.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum