Inner join and append query with Direct query in Power Query

[chchen0202]

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.

[lbendlin]

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

Q2:  Use UNION

[chchen0202]

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]

Q1: let the data model do that for you

Q2: UNION in DAX, not in SQL.