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.
😞
Solved! Go to 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?
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?
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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
433 | |
190 | |
106 | |
57 | |
49 |
User | Count |
---|---|
456 | |
219 | |
128 | |
75 | |
71 |