direct query from db2 for items at powerbi table only

[Anonymous]

Hi,

I have powerbi table, I want to get some figures of this items in table from DB2 table with odbc.

I dont want to import all table to powerbi and make join.

I want select data of items only exist at Powerbi table

[v-cherch-msft · Accepted solution]

Hi @Anonymous

It seems there's no better way to do that with odbc. I would suggest you import the DB2 first:

Then you may use Merge queries for the Query1 and table2 in query editor. Then expend table2 and filter the pno columns<>null.

let
    Source = Table.NestedJoin(Query1,{"item number"},Table2,{"pno"},"Table2",JoinKind.LeftOuter),
    #"Expanded Table2" = Table.ExpandTableColumn(Source, "Table2", {"pno"}, {"Table2.pno"}),
    #"Filtered Rows" = Table.SelectRows(#"Expanded Table2", each ([Table2.pno] <> null))
in
    #"Filtered Rows"

Regards,

Cherie