PowerPivot-Data Model access restriction

[ManuGrewal]

Hello,

I am trying to find a way in which I can allow users to navigate through my excel power pivot table but are unable to see the underlying data model so I can filter out inforamtion of other departments. The specific department user see's there relavent data only. Is there a way to protect the underlying data so users can not access the data model?

Many thanks in advance for your help!

MB

[Syndicate_Admin]

That's not something you can do in Excel Power Pivot.  You would need to move up to Power BI and RLS.