cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
jennratten
Super User
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%...

View solution in original post

1 REPLY 1
jennratten
Super User
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%...

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors