Expression.Error: The column 'Dir.fieldB' of the table wasn't found.
How do I get at the joined table "Dir" within SelectColumns?
Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have the following query in Excel Power Query:
= Table.SelectColumns(Table.NestedJoin(Table.Combine({TableA, TableB}),"PK",TableC,"PK","Dir",JoinKind.Inner),{"FieldA","Dir.FieldB"})
I get the following error:
Expression.Error: The column 'Dir.fieldB' of the table wasn't found.
How do I get at the joined table "Dir" within SelectColumns?
Solved! Go to Solution.
You can try expanding the tables after the join @df555 then getting the columns. That is the easiest way.
= Table.SelectColumns(Table.ExpandTableColumn(Table.NestedJoin(Custom1, {"Digital Property"}, Table, {"Digital Property"}, "Table", JoinKind.LeftOuter), "Table", {"Custom"}, {"Custom"}),{"Digital Property", "Custom"})
Otherwise, you'll need to provide some data because I'm guessing what yours looks like.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou can try expanding the tables after the join @df555 then getting the columns. That is the easiest way.
= Table.SelectColumns(Table.ExpandTableColumn(Table.NestedJoin(Custom1, {"Digital Property"}, Table, {"Digital Property"}, "Table", JoinKind.LeftOuter), "Table", {"Custom"}, {"Custom"}),{"Digital Property", "Custom"})
Otherwise, you'll need to provide some data because I'm guessing what yours looks like.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThis works. I don't even need to use Table.SelectColumns. Thanks!
Excellent @df555 -glad I was able to assist.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting