Forum Discussion

LA09's avatar
LA09
Frequent Visitor
1 year ago
Solved

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...
Need Help
  • GilbertQ's avatar
    GilbertQ
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.