Forum Discussion
Modify linked tables in Power Query for dataflow
While you cannot edit linked entities in a dataflow, you can create a query reference (right-click > reference) and make your modifications there. That creates a computed entity.
Here is the link to the documentation that discusses this in greater detail. https://docs.microsoft.com/en-us/power-query/dataflows/computed-entities-scenarios#:~:text=Computed%20entities%20are%20similar%20to,a%20dataflow%20and%20then%20reused.
While you cannot edit linked entities in a dataflow, you can create a query reference (right-click > reference) and make your modifications there. That creates a computed entity.
Here is the link to the documentation that discusses this in greater detail. https://docs.microsoft.com/en-us/power-query/dataflows/computed-entities-scenarios#:~:text=Computed%20entities%20are%20similar%20to,a%20dataflow%20and%20then%20reused.
Using Query reference is such a cheat code. I want to reference a dataflow, in a new sperate dataflow. But you cannot do that without Premium. Simply pressing reference seems to get round this issue.