Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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%...
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |