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.127 votes
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.
Please bring Calculated Table feature from Power BI into the Excel Data Model. It is very useful to create intermediary tables from DAX calculations and link those tables into the data model.81 votes
We agree that this feature would be useful for many users. The difficulty is that adding this feature would break compatibility for existing Excel users, Data models with this feature would not run in Excel 2013, 2016, or 2019. At this time, we consider compatibility to be more important than this particular feature. At some point in the future we expect to find a way to deal with this compatibility issue, but we won’t be able to address this anytime soon.
- Don't see your idea?