Forum Discussion
Separate Staging and Transformation Dataflows while avoiding "Linked entities are read-only"
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-dataflows. 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?
In your transformation dataflow, reference the linked entity (right click on linked entity and select reference) and make your transformations on the reference query.
1 Reply
- blopez11Super User
In your transformation dataflow, reference the linked entity (right click on linked entity and select reference) and make your transformations on the reference query.