Reply
Frequent Visitor
Posts: 2
Registered: ‎12-13-2018
Accepted Solution

direct query from db2 for items at powerbi table only

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

POWERBI.png


Accepted Solutions
Highlighted
Community Support Team
Posts: 1,392
Registered: ‎07-25-2018

Re: direct query from db2 for items at powerbi table only

[ Edited ]

Hi @theodor

 

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

1.png

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

1.png

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

 

 

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Highlighted
Community Support Team
Posts: 1,392
Registered: ‎07-25-2018

Re: direct query from db2 for items at powerbi table only

[ Edited ]

Hi @theodor

 

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

1.png

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

1.png

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

 

 

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.