Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

I'm getting the error - [Expression.Error] The field 'BUSINESS' of the record wasn't found. The preview is loading fine, yet when I filter this column on specific step to check for errors - it says so: enter image description here

The field is calculated in the previous queries once and it doesn't give any errors. On the 1st step - when I merge, it also doesn't show error. It happens only after I expand merged query fields (the 'BUSINESS' doesn't get merged, it's already in there). I'm ready to smash my head, because I can't see how merging can affect a field which is not being used in it at all, moreover it doesn't have any issues even before.

let
    Source = Table.NestedJoin(GRID_DATA, {"KeyMatch"}, ComPolicy, {"KeyMatch"}, "ComPolicy", JoinKind.LeftOuter),
    #"Expanded ComPolicy" = Table.ExpandTableColumn(Source, "ComPolicy", {"Region", "Chain code", "REGION2", "Vendor Name", "Vendor Number", "PROMOTOOL_TYPE"}, {"ComPolicy.Region", "ComPolicy.Chain code", "ComPolicy.REGION2", "ComPolicy.Vendor Name", "ComPolicy.Vendor Number", "ComPolicy.PROMOTOOL_TYPE"}),

Yet i'm also concerned why does it look for 'BUSINESS' in upper-case when I've never used it in any query in upper case. It might be the issue, I don't see the roots though.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
397 views
Welcome To Ask or Share your Answers For Others

1 Answer

One of the text fields was formatted somehow as number. Very weird that power query didn't give me yellow post with details of error.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...