Forum Discussion
Include in report refresh
Hi Domenico96
All referenced queries are still evaluated separately during refresh, even if they are set not to load, as long as the final query that depends on them is loaded and refreshed. A query is only skipped during refresh if it is neither loaded nor referenced, or if it was previously loaded and later excluded from refresh. Please read this: Referencing Power Query queries
Hi Domenico96
This behaviour often causes confusion when working with appended tables in Power BI.✅ What happens when “Include in report refresh” is disabled?
- When you disable “Include in report refresh” for Sales 2024, Power BI will not query or refresh that table during dataset refresh (either in Desktop or Service).
- The appended table you created (e.g., CombinedSales = Table.Combine({Sales2024, Sales2025})) depends on both tables. If one of them is excluded from refresh, Power BI will use the last cached data for that table.
- Therefore:
- Sales 2024 remains static (it will not update unless you manually refresh it in Desktop).
- Sales 2025 will refresh normally, and the appended table will combine the new Sales 2025 data with the old Sales 2024 data.
✅ When published to Power BI Service
- The dataset refresh in the Service will respect the same setting. Sales 2024 will not be queried again.
- The appended table will not trigger a full refresh of Sales 2024; it will only refresh the tables marked for inclusion.
✅ Best Practice
If Sales 2024 is truly historical and will never change:- Disabling refresh is fine and improves performance.
- Alternatively, you could remove Sales 2024 from the model and load it as a static file (e.g., Excel or CSV) if you want to reduce complexity.
Official Documentation:If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Disabling “Include in report refresh” for Sales 2024 means that table will not be refreshed in Power BI Service, but its data will still be used by the appended table.
When you publish the report, Power BI does not perform a full refresh. Only tables with refresh enabled (for example, Sales 2025) will refresh. The appended table will recompute using cached Sales 2024 data and fresh Sales 2025 data.