Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 18 | |
| 17 | |
| 14 |