Be able to protect Power Pivot data model and measures with password
When you create a data model and measures in PowerPivot with PRO versions, users can modify and edit both.
Users and customers that have no idea on how the model has been build can make a lot of damage and dysfunction.
As well as VBA has it would be very interesting that Power Pivot has the option to be able to protect data model and measures with a password.
eSynapsing
shared this idea
Thank you for suggesting this feature, but this is not something we’re likely to implement anytime soon. The reality is that this sort of feature only helps to keep honest folks honest, and doesn’t provide true security, because anyone with permission to a workbook can modify that workbook. For scenarios where the database really needs to be securely maintained, a better answer is to deploy the data model to either an Analysis Services server or to Power BI. By doing that, the data model (an AS tabular database) will be maintained independently of the workbook, and users will be able to connect to the database and query it from their Excel PivotTables but will not be able to modify it.