PowerPivot : Limit data view

[worthywow]

Hi !

I'm just developing a new PowerPivot dashboard - the source tables all have a country field in them.

I want to create country specific versions of the dashboard where the users can't access the other countries info either directly or by opening up the data model and poking around in the background.

The dashboard will be issued to users so they won't have a direct link to the source data file. I could filter each table in the data model by country but there are numerous tables. Also I could lock down a slicer.

Is there a more elegant way?!

Many thanks in advance for any advice received

Richard

 

[anvg]

Hi
Try with Row Level Security in Power BI
Regards,

 

[worthywow]

Hi - many thanks for the info. However I'm just using PowerPivot/Excel so is there something similar I can do ?

 

[sandy666]

All protection in Excel can be removed in a few seconds except this

it will take a little more time

but you can try Review - Protect Workbook - Structure