Forum Discussion

LA09's avatar
LA09
Frequent Visitor
2 years 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 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!

 

Need Help
  • GilbertQ's avatar
    GilbertQ
    2 years 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.

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years 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.

     

     

     

  • LA09's avatar
    LA09
    Frequent Visitor
    1 year ago

    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.