Forum Discussion
Data Flow Linked Entities
Hello,
I am creating a data warehouse via Data Flow. Reading through the FAQ from Microsoft (https://docs.microsoft.com/en-us/power-query/dataflows/best-practices-for-data-warehouse-using-dataflows), it is recommended that the first architectural layer is a "Staging Dataflow" and the second is a "Transformation Dataflow". How do I reconcile the paradox this creates when "Linked Entities cannot be modified"? When I try to create a transformation dataflow by using the staging data flow as a data source, this error prevents me from applying any transformations. What did I miss?
Thanks
Michael
Hi Anonymous ,
Linked entities are read-only, so if you want to create transformations for a linked entity, you must create a new computed entity with a reference to the linked entity.
You need to create a reference table and do transformations on it:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
1 Reply
Hi Anonymous ,
Linked entities are read-only, so if you want to create transformations for a linked entity, you must create a new computed entity with a reference to the linked entity.
You need to create a reference table and do transformations on it:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai