Exclude a query from semantic model refresh

[LA09]

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!

[LA09]

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]

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.

[GilbertQ · Accepted 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.