Forum Discussion

AndrewPF's avatar
AndrewPF
Helper V
4 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). 

AndrewPF's avatar
AndrewPF
Helper V
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). 

Natarajan_M's avatar
Natarajan_M
Super User
4 months ago

AndrewPF : This error is specific to the Direct query mode as PBI engine cant confirm if they are from the same source and it will work without any issues for Import mode.

Thanks
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster.