Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
LA09
Frequent Visitor

Exclude a query from semantic model refresh

Hello,

 

I have unchecked Include in report refresh for some queries.

I use these queries in an append queries, for which the Include in report is checked because some of the appended queries need refresh.

When I refresh the semantic model, I can see the excluded queries running on the sql server, while I was expecting that they do not run. Is there something I am missing to not have them refresh? I have tried with Enable load unchecked also, without success. 

 

LA09_0-1724271472695.png

 

Thank you!

 

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @LA09 

 

Because the query is used in another append a query, it has to run in order to for full rows requirements. So that is why even though you might remove the tick from include in report refresh, it is still processing the data.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
LA09
Frequent Visitor

Thank you to both of you. To bypass, I use calculated tables with union instead of an append in the power query and it seems to work and to not requery.

Anonymous
Not applicable

Your answer is great GilbertQ 

Hi, @LA09 

As Super User said, you can see the definitions of these two functions in the documentation:

Managing query refresh - Power BI | Microsoft Learn

vjianpengmsft_0-1724649779196.png

vjianpengmsft_1-1724649916261.png

You can exclude certain queries from the Power BI service's refresh via Include in report refresh, but as Super user said, if your other queries depend on this query, it will still query the data. 

If you are still on an older version of Power BI desktop, you can try upgrading your version of Desktop so that your report models are upgraded to an enhanced metadata format. so that Include in report refresh can take effect in Power BI service.

Using enhanced semantic model metadata in Power BI Desktop - Power BI | Microsoft Learn

vjianpengmsft_2-1724650366803.png

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

GilbertQ
Super User
Super User

Hi @LA09 

 

Because the query is used in another append a query, it has to run in order to for full rows requirements. So that is why even though you might remove the tick from include in report refresh, it is still processing the data.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.