Rest API expression error on only some records

[disqodave]

Hi,

I am using a Rest API call to get project story card data. I am unable to determine why PowerQuery returns an expression error for some records but not others. I have no issue returning data using the browser. Here are two examples, both of which return data in the browser but only one works in PowerQuery:

Example 1 (Works fine) - https://www.pivotaltracker.com/services/v5/projects/2632184/stories/184768712/reviews

Example 2 (expression error) - https://www.pivotaltracker.com/services/v5/projects/2632184/stories/185413293/reviews

An error occurred in the ‘’ query. Expression.Error: The column 'Column1' of the table wasn't found.
Details:
Column1

Please help!

[ImkeF]

Hi @disqodave ,
that must have something to do with your M-Code. The way you extract the data after you have imported works for the first example and not for the 2nd. 
This could for example be the case if your reference items in example 1 that are not included in example 2.