MERGE QUERY in DirectQuery mode.

[tanquoc0309]

How can we use the MERGE QUERY in DirectQuery mode.

I tried and get the error: This step result in a query that is not supported in DirectQuery mode.

😞

[Chihiro · Accepted solution]

If queries are from single database (I assume it is, as that's limitation of DirectQuery).

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

Can't you just Join/Union in query statement?

[tanquoc0309]

I think, i need to you join in query statement. Thanks for your answer

[v-ljerr-msft]

Hi @tanquoc0309,

As @Chihiro mentioned above, this is currently a limitation of DirectQuery. And the alternative option is using SQL Statement to join the queries in this scenario.

So could you accept the reply from @Chihiro as solution to close this thread?

Regards