PowerBI Desktop - Expression.Error: We cannot convert the value "[Table]" to type Table

[FullMetalPanic]

Hi all, new here and thanks in advance.

I need to understand what's going on here, been on this for a few hours and can't figure out what might be happening. I have a couple of staging queries that are now bouncing back giving an expression error, about not being able to convert the value of a supposed table to a table type.

This is ocurring during a merged query using Table.NestedJoin as you'll see below from a snip on editor. Can someone point me in the right direction in case something similar has come your way?

let
Source = #"SQL Source",
uni_BKLG_LISTING = Source{[Schema="uni",Item="BKLG_LISTING"]}[Data],
#"Removed Columns" = Table.RemoveColumns(uni_BKLG_LISTING,{"Customer Name", "NEW Sched Ship Date", "Release Date", "ORD STAT"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each ([IsCurrentRecord] = true)),
#"Removed Columns1" = Table.RemoveColumns(#"Filtered Rows",{"TERMS", "BUYER", "BUYER PHONE", "SALES PERSON", "PCODE DESC", "ANALYSIS", "SIZE", "LENGTHS", "SPECS", "SHIP VIA", "BILLING INFO"}),
#"Reordered Columns" = Table.ReorderColumns(#"Removed Columns1",{"Order Nbr", "Order Nbr-Line", "Ship Div", "Customer Number", "Product Code", "SBD", "Scheduled Ship Date", "Status", "Date Shipped", "Inventory Qty", "UOM", "Sales Amount", "ORD STAT Description", "Order Div", "FREIGHT CODE", "FOB", "CUST PO", "ORD QTY", "ORD UOM", "UNIT PRICE", "Master Order", "Contract Release", "Est Ord Cost", "Est Ord GP", "ADDON 1", "ADDON AMT 1", "ADDON 2", "ADDON AMT 2", "ADDON 3", "ADDON AMT 3", "ADDON 4", "ADDON AMT 4", "ADDON 5", "ADDON AMT 5", "EST FREIGHT", "EST PACKING", "REPLACEMENT COST", "REPLACEMENT COMMENT", "REPLACEMENT COST DATE", "LEAD TIME(WEEKS)", "DISPOSITION/STATUS HISTORY", "CUSTOMER PART NUMBER", "PCODE BLOCK 1-2", "PCODE BLOCK 3-8", "PCODE BLOCK 9-10", "PCODE BLOCK 11-13", "SS YEAR", "GetDate", "IsCurrentRecord", "DateKey"}),
#"Changed Type" = Table.TransformColumnTypes(#"Reordered Columns",{{"Scheduled Ship Date", type date}, {"Date Shipped", type date}}),
#"Removed Columns2" = Table.RemoveColumns(#"Changed Type",{"Master Order", "Contract Release", "Est Ord Cost", "ADDON 1", "ADDON 2", "ADDON 3", "ADDON 4", "ADDON 5", "ADDON AMT 1", "ADDON AMT 2", "ADDON AMT 3", "ADDON AMT 4", "ADDON AMT 5", "EST FREIGHT", "EST PACKING", "REPLACEMENT COST", "REPLACEMENT COMMENT", "REPLACEMENT COST DATE", "LEAD TIME(WEEKS)", "DISPOSITION/STATUS HISTORY", "CUSTOMER PART NUMBER", "PCODE BLOCK 1-2", "PCODE BLOCK 3-8", "PCODE BLOCK 9-10", "PCODE BLOCK 11-13", "SS YEAR", "GetDate", "IsCurrentRecord", "DateKey"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns2",{{"Order Div", Number.Type}}),
#"Merged Queries" = Table.NestedJoin(#"Changed Type1",{"Ship Div"}, #"Division Mapping", {"Division Code"}, "Division Mapping", JoinKind.LeftOuter),
#"Expanded Division Mapping" = Table.ExpandTableColumn(#"Merged Queries", "Division Mapping", {"Division Number"}, {"Ship Division Number"}),
#"Removed Columns3" = Table.RemoveColumns(#"Expanded Division Mapping",{"Ship Div"})
in
#"Removed Columns3"

Error as seen after nested join:

Help is appreciated

[v-yangliu-msft]

Hi  @FullMetalPanic ,

This is the related document, you can view this content:

Solved: Cannot convert value to type table - Microsoft Power BI Community

Solved: Cannot convert value to type table - Microsoft Power BI Community

Solved: Re: Cannot convert value to type table - Page 2 - Microsoft Power BI Community

Expression.Error: We cannot convert the value "[Table]" to type Table. Details: Value=[Table] Type=T...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.