Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
40 | |
26 | |
23 | |
21 | |
16 |