Solved: Difference with Enable Data Load & Include in Repo...

Anonymous · ‎09-08-2019

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 · ‎09-09-2019

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-qiuyu-msft · ‎09-09-2019

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rblitz · ‎03-15-2023

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

Anonymous · ‎04-08-2024

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.