Forum Discussion
Solved
merging direct query queries
I have a number of Direct Query queries in my Data Transform view. It works fine until I try to put a merge in one of them. I have found a workaround which is to simply duplicate the query, the...
Thank for your replies but I'm still getting issues even when I use the duplicates solution. I have changed the DQ to import and the problem has gone. As far as I can gather, my data will still refresh (I don't need it in real time).
Hi AndrewPF ,
I believe PBI's Firewall is blocking the merge by assuming that it involves two different query contexts, because it cant guarante that they are from the same source.
QQ : can you push the merge into the DB joins if the tables are coming from the same source ?
Also did you check whether you are getting the same error when you reference the query instead of the duplicate ?
Thanks