Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
In preparation for DP-500 I was reading this from microsoft: https://docs.microsoft.com/en-us/power-query/dataflows/linked-entities
It states:
"Links in the same workspace: When data refresh occurs for a source dataflow, that event automatically triggers a refresh process for dependent entities in all destination dataflows in the same workspace, including any calculated entities based on them. All other entities in the destination dataflow are refreshed according to the dataflow schedule. Entities that depend on more than one source refresh their data whenever any of their sources are refreshed successfully."
This however is a behaviour I'm not seeing. I suspect it's related to the limitation mentioned at the end:
"When using M parameters to address linked entities, if the source dataflow is refreshed, it doesn't automatically affect the data in the destination dataflow."
I'm not using M parameters but I am doing the following to make my code more maintainable:
let
Source = PowerPlatform.Dataflows(null),
Workspaces = Source{[Id="Workspaces"]}[Data],
Workspace = Workspaces{[workspaceName="WorkspaceName"]}[Data],
Dataflow = Workspace{[dataflowName="DataflowName"]}[Data],
Entity = Dataflow{[entity="EntityName",version=""]}[Data]
in
Entity
As opposed to the default that does everything based on specifc GUIDs (?) for each workspace/dataflow.
Questions:
1) Firstly is my hypothesis correct that this causing it not to work or am I missing something.
2) Is there any trick in M to force it to recognise it's lineage.
3) If that is the case is there an existing idea I can upvote to enable the above pattern to work.
Thanks
Ben
Hi @bcdobbs ,
Thank you for posting, but based on your question, I'd like to suggest you open a support ticket to get better support from power BI team.To my knowledge of dataflow, I may not be able to answer your question very well
If you want to suggest some feature improvements or check out ideas that have been proposed by other users, you can refer to this
Best Regards,
Community Support Team _ Caitlyn
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 58 | |
| 56 | |
| 36 | |
| 18 | |
| 14 |