Forum Discussion
"Include in report refresh" checked automatically after being disabled
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.
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.