Credential security with files shared on a network RRS feed

  • Question

  • Does PQ allow for protection of credentials but still allowing users to run queries?  We have information that we are querying where we don't want the credentials to be visible to anyone except specified users.  Is this possible? If so, how do we set up the security to  allow the query to be ran without allowing any but specific users to have visibility of the credentials?
    Thursday, June 15, 2017 9:30 PM


  • Unless you're hard-coding credentials somehow, sharing of credentials shouldn't be an issue. PQ credentials aren't stored in the Excel workbook, but are stored in a user-specific fashion on the local computer. If you authenticate while connecting to a data source, then share your workbook with someone else, they will also have to authenticate in order to refresh the queries. (However, they will be able to see any data you filled to the sheet/data model.) Your credentials aren't shared when you share the workbook.

    Hope that helps.


    Friday, June 16, 2017 5:38 PM