Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Thank you!
Solved! Go to Solution.
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.
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.
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
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
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.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
24 | |
17 | |
17 | |
13 | |
11 |
User | Count |
---|---|
33 | |
21 | |
20 | |
18 | |
11 |