Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
3 years ago

"Include in report refresh" checked automatically after being disabled

Hello,

I have a report where, for a few queries, I have disabled both "Include in report refresh" and "Enable load".

I keep them archived in a separate group for future reference but I do not need the data out of them, just the structure.

 

Now, every time I go back to the query editor of my report, the tick for "Include in report refresh" is activated.

I am very sure I have disabled the refresh and saved the report - I have now done it several times and every time I open the query editor is the same, the check is activated.

 

Do you have an idea what is going on? Is this normal and I have somehow missed it? I have not seen any hint to this behaviour in the official documentaition.

 

Thanks!

Kind regards

Valeria

 

Need Help

8 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi ValeriaBreve 

     

    It doesn't matter. When you disable "Enable load", "Include in report refresh" will be greyed out automatically. This means that it won't be refreshed either. You can go to Power BI Desktop and click "Refresh" under "Home" tab to check which tables will be refreshed. You will find that the tables you don't load into the model will not be refreshed. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

    • ValeriaBreve's avatar
      ValeriaBreve
      Post Partisan
      3 years ago

      v-jingzhang Hi, this is not the behaviour I have observed. I do have quite a few reports where query load is not enabled, but refresh is, and I use these queries to feed multiple other queries that are then formatted/rewroked the way I need to show in PBI Desktop. The "Include in report refresh" is greyed out but still checked, and the queries do refresh. Thanks 

      Kind regards

      Valeria

      • BBrak's avatar
        BBrak
        Advocate I
        2 years ago

        I have been experiencing the same and surprised not just by this behaviour but also the answer above suggesting these queries are not refreshed. They ARE and in my case this is problematic as it is adding huge extra amounts of time. So the question remains, why is it being overridden?

    • Truculent_Llama's avatar
      Truculent_Llama
      Regular Visitor
      1 year ago

      This is incorrect.

      "Enable Load" and "Include in report refresh" are two separate and distinct features.

      "Enable Load" decides whether the table is visible in the DAX front end of the model.

      "Include in report refresh" decides whether the underlying table is refreshed when you press "Refresh".

       

      You can certainly load a table that doesn't get refreshed. Conversely you can also Refresh a table that doesn't get loaded.

      I came here looking for a solution to a problem I'm also having in relation to the second instance. In my case I'm trying to disable refresh on an "archive" table that is a historical data set, then append that to a later data set with the same columns. However, turning off the refresh doesn't seem to be doing anything and when I refresh my model, it's loading tens of millions of rows correlating to my "archive" table.

  • Winniethewinner's avatar
    Winniethewinner
    Helper IV
    1 year ago

    I experienced the same issue.

    I unchcked both, and then Close and Apply, Save the report, publish it to Service. My expectation is this table does not refresh, but it does. 

    And I went back to my desktop version and found "Include in report refresh" gets checked automatically. Although it's greyed out, data still gets refreshed. 


    Hopefully this can be resolved by PBI.