cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
boddydan
Frequent Visitor

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 for when I'm simply putting my data straight from the origin database into a table, however I have a query which combines data from multiple queries into one table, that does not update with the DirectQueries.

let
    Table1 = Table.AddColumn(Table.LastN(#"TABLEfromDIRECTQUERY1",5000),"reference",each "DIRECTQUERY1"),
    Table2 = Table.AddColumn(Table.LastN(#"TABLEfromDIRECTQUERY2",5000),"reference",each "DIRECTQUERY2"),
    Table3 = Table.AddColumn(Table.LastN(#"TABLEfromDIRECTQUERY3",5000),"reference",each "DIRECTQUERY3"),
    Source = Table.Combine({FilterTable1, FilterTable2, FilterTable3})
in
    Source

My visuals use data from this 'merging' query to plot data, so when this query doesn't update with the inidividual tables, my visuals do not work. I would've thought that this query should update as its comprising elements update, however this does not appear to be the case. Does anyone have any advice on how I can get this combined table to refresh with the smaller tables? Thanks.

 

 

1 ACCEPTED SOLUTION

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.

 

View solution in original post

2 REPLIES 2
AlexisOlson
Super User
Super User

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.

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.

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.