Power Pivot-Data Model

[Manu Grewal]

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 information of other departments. The specific department user see's there relevant data and not all department data . Is there a way to protect the underlying data so users can not access the data model?

Many thanks in advance for your help!

MG

 

[Matt Allington]

The only secure way is to migrate the model to Power BI and implement row level security.