Feedback by UserVoice

eSynapsing

My feedback

  1. 477 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    eSynapsing supported this idea  · 
  2. 346 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for being able to protect Power Query with a password. This is a good idea, but we don’t think we’ll be able to support this in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    eSynapsing supported this idea  · 
  3. 127 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on 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.

    eSynapsing shared this idea  · 

Feedback and Knowledge Base