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 DirectQuery mode"

 

Q1. It is possible for Direct query table to apply【Merge queries】with 【Inner join】to other table (Left join is avaliable)? if not, are there any alternative method (without using SQL)? Is this a limitation of DQ mode?

 

 

 

 

 

Q2. Similarly, is it possible to use 【Append queries】 to other table? Are there any other alternative solutions available (without using SQL UNION statement)?

 

Thank you in advance. Best regards.

Need Help
Tips and Tricks

3 Replies

  • 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.