Forum Discussion
Modify linked tables in Power Query for dataflow
Hi everyone,
I created a dataflow for my workspace, and one of the tables in it is linked to another dataflow. I need to do some queries and I want to do them online into the dataflow but I have this message saying that linked tables can't be modified. And I indeed can't save my modifications, I just can load the entire table.
Does anyone know why we can't do this and if there is any workaround?
Thank you in advance!
arthurld
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.
2 Replies
- jennratten
Super User
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.
