Data Flow Linked Entities

[MCK003]

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-dataf...), 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

[v-deddai1-msft · Accepted solution]

Hi @MCK003 ,

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