My (Win10) system password expires in a few days. Last time I changed it, I then had to spend a long time going through all my .pbix reports individually and re-entering credentials, as most of them draw on one or more OneDrive/SharePoint files/folders. As I have about 50 (and counting) different Power BI reports this quite a task that will need repeating again this time and then every time after this that I need to change my password.
I was wondering if anyone had any useful ideas about how to avoid this, or at least shorten the process.
I don't have a good grasp on system connections & how Power BI connects with and gains the appropriate approvals and credentials to pull the data from Sharepoint/OneDrive. Does anyone have any ideas/tips, that means longer term changing my (indidivual) system password won't cause me such a headache? PBI service seems a little more straightforward, than the destop files which are my main concern,but any ideas/tips for either/both would be really helpful.
Thank you.
Matt
