Forum Discussion

boddydan's avatar
boddydan
Frequent Visitor
4 years ago
Solved

Have realtime DirectQuery working as intended - Update a query that combines multiple queries?

Hi everyone, I've followed a tutorial (https://www.youtube.com/watch?v=iyGBZsLxe54) using Play Axis to have my report refresh my DirectQuery datasets in realtime (~10 seconds). This works very well ...
Need Help
Tutorial Requests
  • boddydan's avatar
    boddydan
    4 years ago

    Thanks for the reply. The DirectQueries are coming from the same SQL server (thanks for the hint- I think I have been importing them in a strange way) but are just different tables in the same database. I've been able to get my combinational query to work just now using the 'Append Queries' button.

     

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

If these DirectQueries are coming from separate sources (e.g. not all from the same SQL server) then I'm not sure there is a way to combine these without switching to import mode.

 

It's not elegant, but one possible workaround is to write separate measures for each source and then a unifying measure that combines or switches between them as appropriate.

boddydan's avatar
boddydan
Frequent Visitor
4 years ago

Thanks for the reply. The DirectQueries are coming from the same SQL server (thanks for the hint- I think I have been importing them in a strange way) but are just different tables in the same database. I've been able to get my combinational query to work just now using the 'Append Queries' button.