Forum Discussion

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

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

 

1 Reply

  • Anonymous's avatar
    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

     

    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