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 ...
Need Help
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?

      • ValeriaBreve's avatar
        ValeriaBreve
        Post Partisan
        2 years ago

        Hi BBrak, I did not get any other answer on this. It has happened in an erratic manner in my reports... I have not understood yet what might trigger it.

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