cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
analytics_uk
Helper I
Helper I

Append 2 Queries - turn off refresh on only 1 of the queries

Hi, 

As the title says I want to append two queries but I want only 1 of the queries to refresh.

I have tried to untick 'include in report refresh' for the query in question but in the appended query it refreshed this table as well!

any help will be much appreciated!

1 ACCEPTED SOLUTION

@analytics_uk Well, one option that you might have would be to ditch the Append query and load both tables into the model. Hide them and create a DAX UNION table. You could then disable refresh on the one query and then it won't refresh. Granted, more data in your data model but maybe that's OK. You also might try enabling load on the query you don't want to refresh (I'm assuming it is disabled) and see if that prevents it from refreshing. I don't think it will. 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

@analytics_uk Do you have a total of 3 queries, so your two source queries and then a separate Append query?


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

@Greg_Deckler  Yes, so that is using 'Append Query as New'.

I have tried the other way as well - so just 'Append Query' where I will have 2 queries in total but the same issue persists !

@analytics_uk Well, one option that you might have would be to ditch the Append query and load both tables into the model. Hide them and create a DAX UNION table. You could then disable refresh on the one query and then it won't refresh. Granted, more data in your data model but maybe that's OK. You also might try enabling load on the query you don't want to refresh (I'm assuming it is disabled) and see if that prevents it from refreshing. I don't think it will. 


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

View solution in original post

@Greg_Deckler thanks, this works although like you say it duplicates the data for the queries in question. The only other thing I can think of that won't do this is to load the query i don't want to refersh as a csv. since it'll be a static file i think that might work as well!

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.