Automatically Refresh Data from Power BI in Excel via Connection

[Chris_23]

Hello,

I have the following issue: Data is imported from Power BI into Excel every morning via a connection. Since I reset my password a week ago, I have to re-authenticate my Microsoft user every time the connection updates. What do I need to do to return to the previous state before the password reset, where I only had to log in once and the credentials were then saved, eliminating the need to log in again each time?

Thanks

Chris

[collinq · Accepted solution]

Hey @Chris_23 ,

In Excel, in the Data Connections option is the "save password" option.  (Under properties for the connection).  Make sure that this is checked