Forum Discussion
Difference with Enable Data Load & Include in Report Refresh
Hi,
I am looking to gain more insight about the above two functionality. when to enable or disable these options for your queries. what impact it has on the performance of your dataset.
Thanks
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
3 Replies
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 YuIf there were two queries referencing the base query that has Enable Load off, will the base query be called twice?
