Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I read something on radacad informative site "You can create a reference even from a query that is the disabled load. However, that is not called a Computed entity, and as a result, it won’t have the special behavior that I mentioned about the data refresh from the staging area. It will be only considered as a computed entity if the original query is set as enable load"
https://radacad.com/linked-entities-and-computed-entities-dataflows-in-power-bi-part-4
I'm a bit confused.
I have two workspaces, one for ingestion and one for transformation.
In the transformation workspace, I create a linked entity to the ingestion workspace. I am using premium capacity.
From here there are a few options and I'm not sure what is the "right" way forward. Lets assume I have a small set of PQ transform steps to apply.
Option 1A : mark the linked entity as disable load. create refernce entity, apply PQ steps and ensure entity is loaded
Option 1B : mark the linked entity as enable load. create refernce entity, apply PQ steps and ensure entity is loaded
Option 2A : mark the linked entity as disable load, apply PQ steps. create final referenced entity
Option 2B : mark the linked entity as enable load, apply PQ steps. create final referenced entity (not possible as linked entitys can have transformation steps and be loaded)
I only really want to see one final entity in the transformed workspace, so prefer Options 1A and 2A that have the entity disabled.
The advice seemed to be that you needed the linked entity enabled for your referenced entity to be considered a computed entity ie Option 1B above ?
What does "enable load" actually do behind the scenes. It makes the linked entity visible but is it doing something behind the scenes with ADLg2 ? The originating entity has already been loaded in ADLg2 so surely this doesn't load another set of that data ?
Is there a performance issue by turning off the enable load ?
Thanks !
Hi @frano72 ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Will the linked entity still refresh? Or is it static with the data that existed before enable load was disabled?
For my dataflow, I don't need the linked entity to load into a report. I just need a few fields to merge into the main entity. But the data does update constantly so it has to be a fresh pull. I'm trying to figure out if unchecking enable load prevents keeping the linked data current.
HI @Anonymous ,
There are two options - enable load and refresh. You can disable the load but keep the refresh Enabled.
Proud to be a Datanaut!
Private message me for consulting or training needs.
I'm familiar with that on the desktop version. For the PBI Service however, where I'm creating my dataflows, I don't actually see the refresh option when I right click the table. Only the Enable Load. Is it housed somewhere else perhaps?
HI @Anonymous ,
My apologies, I didn't realize this was about a dataflow. I do not think there is an "include in report" and you have only the "enable load" or not option. And, therefore, if you are using data (even a few columns only) you have to enable load for the whole data source. maybe you can make a mini-version of the larger data source somewhere to get a smaller data source to load as your merge columns?
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @frano72 ,
Linked entities are read only. If you want to create transformations for a linked entity, you must create a new computed entity with a reference to the linked entity. The Linked entities have no transformation , no storage , read only , just a link.
The computed entities can be good for performance .Main table is stored in Power BI Dataflow storage, and the new table will query the main table (not the data source).
If your dataflow isn’t in a Premium capacity workspace, you can still reference a single query or combine two or more queries as long as the transformations aren’t defined as in-storage transformations. Such references are considered standard entities. To do so, turn off the Enable load option for the referenced queries to prevent the data from being materialized and from being ingested into storage. From there, you can reference those Enable load = false queries, and set Enable load to On only for the resulted queries that you want to materialize.
For reference:
Link entities between dataflows in Power BI
Dataflow Integration Solution for Power BI
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @frano72
Enable Load outputs the Data into the data lake ( dataflows ) Power BI desktop ( Model/dataset )
If Enable Load is disabled the query will not run or else is being referenced by any of the Enable Load Entities
Dataflows final output always ends in a data lake as SCV file, so linked entity will be calculated first when backed premium capacity and in the same workspace, or if referenced it will use existing data in the referenced dataflow and apply extra transformations on top and again write into data lake as SCV
https://www.youtube.com/watch?v=veuxofp0ZIg