Enable Load For Linked Entity Dataflows

[akhaliq7]

Is it okay to turn off the enable load for linked entities within my dataflow? This removes the lightning symbol, which makes me think it's not good. The computed entities will still be on for building reports.

[frithjof_v · Accepted solution]

If you disable the load of the linked entities, then the computed entity cannot use the enhanced compute engine so your performance will likely suffer.

Why do you want to disable the linked entity?

My understanding is that if you disable the linked entity, you step down to "Pro features". If your linked entities are enabled, you take advantage of "Premium features".

This is where I found this information, under the "Enhanced Compute Engine" section:

https://data-marc.com/2020/06/09/how-to-keep-your-power-bi-dataflows-organized-and-optimized/

A very useful YouTube video which explains that the enhanced compute engine is able to take advantage of query folding against a SQL cache:

https://youtu.be/h_FsjK_-Ick?si=EKpEXOXbovupaT2_

[uzuntasgokberk]

Hello @akhaliq7,

İf there is a lighthing icon that means Computed Tables and you can use in premium licence such as referance, merge etc.

But if you turn off the enable load in your table(lets say A table) you will not see the A table when get the data from the dataflow A table. But you refereanced A table and your new table name is B and when you try to get data, you can see B table and it will be sync with A table.

İf you really doesn't need A table that more efficient way. You can think like Power BI Desktop version.
C target=_blank target=_blankreating computed tables in dataflows - Power Query | Microsoft Learn

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |