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.

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors