Forum Discussion
Copy relation from one table to another
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?