topic Re: Data Flow Linked Entities in Service

Data Flow Linked Entities

Anonymous — Wed, 17 Mar 2021 05:19:44 GMT

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

Re: Data Flow Linked Entities

v-deddai1-msft — Fri, 19 Mar 2021 07:12:36 GMT

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