how can I preserve my olap security settings when using powerview?

Question

Hi.  The way it was explained to me, there will be two ways for my olap data to be accessible to power view.  One by exporting it to a tabular mode database and then plumbing that db as a datasource to powerview.  Or two by making a powerPivot data source and plumbing that source as a data source to powerview.

My guess is that the first will not preserve my ssas security logic coding and roles unless I completely duplicate that logic in the tabular mode db.

Assuming individual credentials can be passed to the olap server regardless of number of hops, will the second option preserve my olap security coding and roles?  

Answer 1

Your guess is correct. You can create a tabular model using a multidimensioinal model as a data source but you would need to implement a security model in the SSAS tabuler model.

Regards,

Luis

Answer 2

thx Luis.  Does option 2 preserve this kind of security info?

Answer 3

I have am not familiar enough with option 2. I will see if I can try that later on today.