Forum Discussion

initpro's avatar
initpro
Regular Visitor
9 years ago

Copy relation from one table to another

Is there a way to copy the relations from one table to another table. I have a few filtered tables with the equal table structure and like to use the same dimension tables.   thanks for your suppo...
Need Help
initpro's avatar
initpro
Regular Visitor
9 years ago

I have one table t1 which includes data from different section.

This table has a lot of relations to other tables.

My filtered table t2 based on t1 and should have the same relations to the other tables.

 

therefore I am asking for a convenient way to relate these tables

 

 

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

You can use Autodetect feature for relationships to be automatically defined. 

For more information, Please refer to this documentation from microsoft here.

 

 

Thanks & Regards,

Bhavesh

 

 

  • initpro's avatar
    initpro
    Regular Visitor
    9 years ago

    thanks for the hint.

    I know this feature but even I let to detect auto relation then also other relations are made with no sense.

    It would be fine to autodetect relations onle from tables of my choice.

    • HarrisMalik's avatar
      HarrisMalik
      Continued Contributor
      9 years ago

      initpro What is the reason of having a filtered table with exactly the same dimension tables? what you are trying to achieve?

       

      Regards

      Harris

      • initpro's avatar
        initpro
        Regular Visitor
        9 years ago

        the reason for this filtered table is that I use the Power bi free account and I like to offer our customer data on a dashboard.

        The free account does not allow row security on different roles.

        If I try to filter rows for a certain dashboard this filter is also shown on the reportdata for a special dashboard and the user that has access to this dashboard is able to delete the filter and see than all data.

        So my thoughts behind was I publish only these filtered table data.

        But at the moment it's not possible to show filtered table data on the dashboard tile, it seem this is a bug of the service.

         

        I hope my explanation was understandable.