Forum Discussion

dm1904's avatar
dm1904
Helper I
6 years ago

Model Relationships with Dataflows

Hi, I'm wondering if somebody can help me get my head around this.   I host a dataflow for a Group of 5 other report Authors. Each of those authors use the same data from the Dataflow, but create r...
Need Help
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi dm1904 

 

Unfortunately at the moment, you can not share parts of the dataset as its a whole entity, maybe in the future composite models will include the ability to mix different datasets, but for now, you have the choices that you have listed. Dataflows or Datasets

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

 

dm1904's avatar
dm1904
Helper I
6 years ago

Mariusz  Thank you, I undestand that part.

 

So coming back to the Dataflow Scenario, is it possible to build relationships between entities within the Power BI service - For others to consume? Or is there no other way to centrally manage a model for multiple report authors with Dataflows? And therefore I should stick with Shared Datasets with its limitations

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi dm1904 

    I think Shared Datasets in power bi is better.

     

    Regards,

    Lin

  • graemeg's avatar
    graemeg
    Frequent Visitor
    5 years ago

    I also have the same requirement where I want to have a single Dataflow model that can be used by multiple users and for me to define the relationships between the entities so others can use it.  The database I'm connecting to is Common Data Services, the tables get created exactly as expected in the Dataflow and I cannot find a way of then defining the relationships between the tables.  Did you manage to solve the problem?