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...
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.

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.