Forum Discussion

Chris_23's avatar
Chris_23
Helper II
2 years ago
Solved

Automatically Refresh Data from Power BI in Excel via Connection

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

  • 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

1 Reply

  • 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