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
Solved! Go to Solution.
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%...
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%...