• Services
    • Roles
    • Business Intelligence
    • Migration, Implementation and Training
  • Blog
    • Archives
  • About
  • Partners
  • Contact

Call us toll free 0800 1800 900

Find us on Map
rt@cpa-it.com
Login

Login
White-Knuckle Consulting White-Knuckle Consulting
  • Services
    • Roles
    • Business Intelligence
    • Migration, Implementation and Training
  • Blog
    • Archives
  • About
  • Partners
  • Contact

Password not saved in PowerPivot connection when using SQL authentication

Sep 2, 2015 | BI |

When using SQL authentication in a PowerPivot connection, I repeatedly found the password was not saved even though I had removed the check mark from “Blank password” box and the “Allow saving password” box was checked. I tried manipulating the advanced properties setting the persist security to “True”.   All to no avail… the password was saved until the spreadsheet was closed, but the user was required to enter the password when the spreadsheet was re-opened and the PowerPivot data refreshed.

PowerpivotAuth1

Turns out, you need to do the above and set some properties of the connection back in Excel. In the main Excel window in the Data tab, choose Connections, then select the workbook connection that corresponds to your PowerPivot connection. Click on Properties, switch to the definition tab, and mark “Save password” box.

PowerpivotAuth2

This setting will allow for permanent storage of the SQL account password.  Note the password is stored in plain text, so consider the security implications.

Share

Leave a Reply

Your email is safe with us.
Cancel Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact Us

Let us know how we can help you, and we will get back to you asap!

Send Message

© 2022 · White-Knuckle Consulting, LLC

  • D365 for Finance and Operations / Dynamics AX consulting – White-Knuckle Consulting
  • About Us
  • Services
  • Blog
  • Contact
Prev Next