Forum Discussion

Max_701's avatar
Max_701
Helper II
1 year ago
Solved

Dataflow Gen1 - Index Issue

I have a Gen1 Dataflow which gets fed into a linked entity in a child dataflow. The whole setup looks like this  REST API ->Parent DF1 ->Child DF2 ->Report. Parent DF1 has an index column which goes...
Need Help
  • collinq's avatar
    collinq
    1 year ago

    HI Max_701 ,

    This is actually by design I believe.  This is because each "table" is getting its own index.  So, the parent gets one and then the child gets another one.  There are a few workarounds depending on how you want to do it.  But, the easiest is probably to generate the index after the loading of the child table.

    Another option would be to change the linking - so that the child is not referenced but rather linked (but that might not be really the way you want to do it).

Max_701's avatar
Max_701
Helper II
1 year ago

Thanks for the response! You mentioned another way would be to chnage the linking - could you please elaborate? Currently the DF2 uses only linked entitites from multiple parent dataflows, if this helps in better understanding of the setup.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Max_701,

     

    when you use linked entities, Power BI runs the steps again — so the index gets recalculated and doesn't stay the same. To keep the original index from the parent dataflow, you need to use a computed entity, which actually brings in the data as it is, without redoing the steps.

     

    Regards,

    Vinay Pabbu