Forum Discussion

robarivas's avatar
robarivas
Icon for Post Patron rankPost Patron
9 years ago

Large Table performance

I'm connecting to an IBM DB2 database (z/OS) via ODBC (cause I could never get the built-in connector to work). Most tables are viable. However, I cannot find a way to get the transactions table data...
Need Help
robarivas's avatar
robarivas
Icon for Post Patron rankPost Patron
9 years ago

Ok, maybe I'll get a response if I ask the question a little differently:

 

Why would Power Query stop Query Folding upon the simple act of filtering a column?

 

let
     Source = Odbc.DataSource("dsn=ABCD", [HierarchicalNavigation=true]),
     ABC_Schema = Source{[Name="ABC",Kind="Schema"]}[Data],
     ABC1234_View = ABC_Schema{[Name="ABC1234",Kind="View"]}[Data],
     #"Removed Other Columns" = Table.SelectColumns(ABC1234_View,{"TX_DATE_POST", "ORDER_ID", "CORP_ID", "ORDER_SITE", "PRODUCT_ID", "ORDER_TYPE", "TX_ID", "TX_AMOUNT", "TX_QTY"}),
     #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each [CORP_ID = "54"),