Modify linked tables in Power Query for dataflow

[Anonymous]

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

[jennratten · Accepted 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%...

[dkuhne]

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.