Forum Discussion
itchyeyeballs
Impactful Individual
Impactful IndividualManage pbix files within team
Hi all, Would like to get some ideas on how we can best manage our .pbix files, we have a team of analysts who will all need to be able to access and modify the files, we have a relatively small ...
Yes. Generally you implement RLS to show the data only relevant to the user. If you need totals for the business, user share if total etc, then you would need an aggregate table to do that work for you.
itchyeyeballsImpactful Individual
Impactful IndividualThanks Matt,
Does that mean we need to pre-aggregate all the data before import to model?
We need the users to see summaries/analysis of entire dataset (and be able to slice and dice by lots of metrics), just not be able to get at raw level.
Our main concern is we don't know all the caveats, it's hard to find a definitive guide on how to make models secure, there could be X number of ways to do things that we don't even know about.
Does that mean we need to pre-aggregate all the data before import to model?
We need the users to see summaries/analysis of entire dataset (and be able to slice and dice by lots of metrics), just not be able to get at raw level.
Our main concern is we don't know all the caveats, it's hard to find a definitive guide on how to make models secure, there could be X number of ways to do things that we don't even know about.
MattAllington
Community Champion
Community ChampionYes. Generally you implement RLS to show the data only relevant to the user. If you need totals for the business, user share if total etc, then you would need an aggregate table to do that work for you.