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 support

initpro You are trying to use filtered table for security setup which is not a good idea. You are also right about the unavailability of row level security in free version. What you are trying to achieve and without having to map the facts and dimensions for each table can be done quickly like this: - Suppose you have Table X having sales data for three countries US, NL, DE - You have three sales managers PersonUS, PersonNL, PersonDE who should only see the sales of corresponding regions - You have a sales director who should see all sales - You can create a Power BI files and in source query use something like; Select ColumnA, ColumnB,ColumnCFrom X It will give you all the records. You can use this table for mapping the dimensions as you have already done.Create report(s) from this data source. Now make three copies of PBIX file. Go to each file and change the source query for each country in respective file e.g. Select ColumnA, ColumnB,ColumnCFrom XWhere Country='US' Only changing the source query will now filter the data for this pbix without having to re-mapp all the dimensions. You can publish all the four reports to Power BI. and create seperate dashboards like Sales Global, Sales US etc. Share each dashboard with concered manager. RegardsHarris

What do you meany by this? can you please elaborate and if possible post a data model.

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

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

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.

Copy relation from one table to another | Microsoft Fabric Community

11 Replies

BhaveshPatel
Super User
10 years ago
What do you meany by this? can you please elaborate and if possible post a data model.
- initpro
  Regular Visitor
  10 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
    Super User
    10 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

Forum Discussion

Copy relation from one table to another

11 Replies

Related content

2 tables connected (related) by 2 tables

Unable to Relate to another Table

Filtercontext with date relation

Power Query LookUp in another table

Lookupvalue from another table not related