Forum Discussion

chchen0202's avatar
chchen0202
Frequent Visitor
2 years ago

Inner join and append query with Direct query in Power Query

Hi all,   I am a beginner in Power BI.  I have two questions regarding tables in direct query mode, because I got the similiar error msgs : "This step results in a query that is not supported in D...
Need Help
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
2 years ago

Q1: Let the data model do the work for you.

 

Q2:  Use UNION

  • chchen0202's avatar
    chchen0202
    Frequent Visitor
    2 years ago

    Thanks for reply,

    Q1: I need to do some transfer after inner join, like rename column name and remove duplicate, so is it possible to do inner join in the PowerQuery level? 

    Q2 : For some reason, I can not to do SQL query in advance, so are there any other alternative solutions available?

     

    Thanks

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Q1: let the data model do that for you

      Q2: UNION in DAX, not in SQL.