Forum Discussion

AndrewPF's avatar
AndrewPF
Helper V
5 months ago
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...
Need Help
  • AndrewPF's avatar
    AndrewPF
    4 months ago

    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). 

Anonymous's avatar
Anonymous
Not applicable
4 months ago

Hi AndrewPF,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Natarajan_M and BeaBF  for prompt and helpful responses.

 

Great to hear that it’s working as expected on your end!

This behavior is due to a Direct Query limitation related to Power BI’s data privacy (firewall), where the engine cannot guarantee that both queries come from the same source, which blocks the merge operation.

Switching to Import mode removes this restriction, which is why your approach works fine.

 

I’d suggest marking your approach as the solution so it can help others facing the same Direct Query firewall limitation.

 

Thanks & Regards,

Prasanna Kumar