Rest API expression error on only some records

disqodave · ‎09-14-2023

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 · ‎09-14-2023

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries