Forum Discussion
MERGE QUERY in DirectQuery mode.
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.
:(
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?
3 Replies
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?
- I think, i need to you join in query statement. Thanks for your answer
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? :smileyhappy:
Regards
