Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
bcdobbs
Community Champion
Community Champion

Dataflows Linked Entity Refresh

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

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
1 REPLY 1
Anonymous
Not applicable

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

vcaitlynmstf_0-1652173204070.gif

 

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.