Forum Discussion
Difference with Enable Data Load & Include in Report Refresh
Hi Anonymous,
If we disable the option "Enable Load" for the query, when we apply the change, this query table data will not be loaded to data model. But when we refresh the dataset, there is also a query sent to data source. See: https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up
When we disable the "Include in Report Refresh" option, data will not update in report view of Power BI Desktop after you click "Refresh" button in Desktop. It does nothing to the power BI Service.
Best Regards,
Qiuyun Yu
Hi Anonymous,
If we disable the option "Enable Load" for the query, when we apply the change, this query table data will not be loaded to data model. But when we refresh the dataset, there is also a query sent to data source. See: https://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up
When we disable the "Include in Report Refresh" option, data will not update in report view of Power BI Desktop after you click "Refresh" button in Desktop. It does nothing to the power BI Service.
Best Regards,
Qiuyun Yu
If there were two queries referencing the base query that has Enable Load off, will the base query be called twice?
I don't believe so, but have seen conflicting information on this. My understanding is that the query is sent just once (for the base table), but may be wrong and happy to be so if someone else can enlighten me.