Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
@initpro What is the reason of having a filtered table with exactly the same dimension tables? what you are trying to achieve?
Regards
Harris
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.
@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,ColumnC
From 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,ColumnC
From X
Where 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.
Regards
Harris
Thanks Harris for your comment
only a question:
does the filtered table includes the data after publishing or is the filtered table only a view to the base table?
@initpro as you are filtering in the source so each report will be published with filtered data. When you will create seperate dashboards from these reports they will also have only filtered data
If you are asking about whether the data is pushed to cloud or not? if you are using import data feature the data will be pushed to cloud (Still filtered) and in DirectQuery mode it will not.
thanks Harris
is direct mode with free account possible?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
104 | |
77 | |
71 | |
50 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |