Forum Discussion

EVEAdmin's avatar
EVEAdmin
Icon for Post Patron rankPost Patron
5 years ago
Solved

SQL Credentials

Hello all! On Power BI Desktop, I built a report where the data source is a MS-SQL Server.  Clearly, the credentials are stored. What I would like to understand is where the credentials are stored...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    The credentials are stored on your local PC and are not shared when you share the PBIX file.  If a new user tries to refresh the data, they would get prompted to enter credentials.  To share your report and have it auto-refresh, you would need to publish it, set up a Gateway to store the credentials securely, and set up scheduled refresh.

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

The credentials are stored on your local PC and are not shared when you share the PBIX file.  If a new user tries to refresh the data, they would get prompted to enter credentials.  To share your report and have it auto-refresh, you would need to publish it, set up a Gateway to store the credentials securely, and set up scheduled refresh.

Pat

 

EVEAdmin's avatar
EVEAdmin
Icon for Post Patron rankPost Patron
5 years ago

thank you mahoneypat , appreciated. 
I am running Power BI Service too but needed clarification on this specific subject.

Thank you again.