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
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
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
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!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors