question

ProKelly avatar image
ProKelly asked

Excel Service data model refresh on open

In SharePoint 2013, I have a PowerPivot excel spreadsheet sitting in a gallery, and it's a dashboard that's underpinned by financial data. I want that model to refresh as the user opening the sheet (right back to the data source) so that the user only gets the data they're allowed to see, governed by the security in the tabular cube delivering the data. Is there anyway to force this? or alternatively how can I apply a secure model of finance data that provides only relevant user data, as prescribed by the tabular model?
excelpower-pivot
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.