Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

SQL IN parameter from the existing column in Power BI table

Hi All,

 I am excuting the SQL IN query from SAP Database and rather than manually enter the IN data (e.g. mobile numbers) and then refresh the table, I want the SQL IN to automatically pick up the data from a column(mobile number) present in existing table(table 2) in same Power BI desktop.

 

Eg. 

Select * from table 1

where field3 IN ( mobile number from table 2)

 

table 2

Mobile number

111111111

222222222

333333333

444444444

555555555

 

Need Help

3 Replies

  • ThxAlot's avatar
    ThxAlot
    Super User
    3 years ago
    Calculated Table = 
FILTER(
    Table1,
    NOT ISEMPTY(
        FILTER( Table2, Table2[Mobile number] = Table1[Field3] )
    )
)

     

    In terms of SQL in your scenario, EXISTS() is more efficient than IN

    SELECT *
FROM Table1
WHERE EXISTS(
    SELECT NULL FROM Table2 WHERE Table2.[Mobile number] = Table1.Field3
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      What is the this used for Calculated Table = FILTER( Table1, NOT ISEMPTY( FILTER( Table2, Table2[Mobile number] = Table1[Field3] ) ) ) Can we use Dynamic M Parameter. If yes, can you please show step by steps

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    My Table 1 is an SQL IN function from external database and it should pick up the IN data from the existing data in POwer BI desktop which is from different source.