Separate Staging and Transformation Dataflows while avoiding "Linked entities are read-only"

[henrylynch]

Hello! We have started having performance issues with our dataflows, so I am trying to follow best practice and separate our dataflow into a "staging" dataflow and a "transformation" dataflow per this documentation: https://learn.microsoft.com/en-us/power-query/dataflows/best-practices-for-dimensional-model-using-d.... However, in the "transformation" dataflow (which is linked directly to the tables I need from the "staging" dataflow), I'm getting an error that linked entities cannot have any transformations done on them. Am I configuring this wrong?

[blopez11 · Accepted solution]

In your transformation dataflow, reference the linked entity (right click on linked entity and select reference) and make your transformations on the reference query.