Hello,
We have a project where we need to make dashboards for different people in the company.
The first one is for the top boss, who wants to see the general information for all the verticals.
The next ('child') is for the leaders of each vertical, and the final one for the end-client.
What we have done is in the first one, input all the data from our databases and for the second one (the child), import the semantic model of this first one and in this one add some excel files we have for the specific vertical, and the same for the next level which is end-client. The point in doing this is that, eventually the plan is to have a dashboard for each vertical (there are many), and a dashboard for each end-client (which are even more), and everytime we make a change, all the "children" and "granchildren" will have them as well and not have to do each change manually.
The problem is we would like to filter the semantic model when importing it to the next powerbi, so that we only import the data from that vertical and the data from other verticals is not available.
Is it possible?
