Forum Discussion

PowerBIFin's avatar
PowerBIFin
Advocate I
4 years ago

WorkspaceID or DataflowID as Parameters in linked entities

Has anyone tried to parameterized the WorkspaceID and DataflowID in Linked Entities? I noticed it losses it's 'linked entity' capability when I do this, which means these tables no longer gets updated automatically when the main source table is refreshed.

 

From

 

let
  Source = PowerBI.Dataflows(),
  Workspace = Source{[workspaceId = "1a952272-6b18-4429-a3b0-exxda95"]}[Data],
  Dataflow = Workspace{[dataflowId = "1a952272-6b18-4429-a3b0-xx0da95"]}[Data],
  Entity = Dataflow{[entity = "Transactions"]}[Data]
in
  Entity

 

 To

 

let
  Source = PowerBI.Dataflows(),
  Workspace = Source{[workspaceId = WORKSPACEID]}[Data],
  Dataflow = Workspace{[dataflowId = DATAFLOWID]}[Data],
  Entity = Dataflow{[entity = "Transactions"]}[Data]
in
  Entity

 

 

 

 

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi PowerBIFin 

     

    Linked tables can't be modified. Once you parameterize the WorkspaceID and DataflowID in Linked Entities, they are no more Linked Entities so they cannot get updated automatically when the main source table is refreshed. In this scenario, you need to refresh the dataflow which has these modified entities. 

     

    You may refer to this blog How to modify a linked entity in Power BI dataflows - RADACAD. I think Reza Rad's comment explains how to understand this problem well -- "When it is a linked entity, the entity LIVES in the original workspace, and chained dataflows will connect to it only without a copy of the original. using the method mentioned here, we are actually importing this as another entity. and yes, there will be an import (and data refresh) from the other dataflow into this one."

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.