Forum Discussion

TallKewlOnez's avatar
TallKewlOnez
Helper I
6 years ago
Solved

Inner Join with custom conditions

I need to reproduce an MSSQL Join in PowerBI, please help (yes I am new)   SELECT [dbo].[Table2].[sID], [dbo].[Table1].[rVer] FROM [dbo].[Table1] JOIN [dbo].[Table2] ON [dbo].[Table2].[sName] = ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous solution is ok but don't merge in power query, just load both the tables and set relationship between the tables on the columns you are using for join in SQL, but yes, do the replacement in Power Query

     

    Merge is an expensive query and if not required, one should avoid it.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous solution is ok but don't merge in power query, just load both the tables and set relationship between the tables on the columns you are using for join in SQL, but yes, do the replacement in Power Query

 

Merge is an expensive query and if not required, one should avoid it.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

TallKewlOnez's avatar
TallKewlOnez
Helper I
6 years ago

Thanks very much