Difference with Enable Data Load & Include in Report Refresh

[Sumegha]

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

@GuyInACube 

[v-qiuyu-msft · Accepted solution]

Hi @Sumegha, 

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 

[rblitz]

If there were two queries referencing the base query that has Enable Load off, will the base query be called twice?

[Alex25]

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.