Hop to simplify refresh oAuth2

[JdL42]

Hi. I use PowerBI desktop with Excel files located on a SharePoint site. I use oAuth2 without any problem. Each day, reports are automaticaly refreshed. But in my company, we are supposed to change our password each two months. Each Time I have to refresh file per file the oAuth2. Is there a better way to do this ?

[Eric_Zhang · Accepted solution]

---

@JdL42 wrote:

Hi. I use PowerBI desktop with Excel files located on a SharePoint site. I use oAuth2 without any problem. Each day, reports are automaticaly refreshed. But in my company, we are supposed to change our password each two months. Each Time I have to refresh file per file the oAuth2. Is there a better way to do this ?

---

@JdL42

From Power BI development aspect, there's no public REST API that do that. So I'm afraid that you'll have to update the credential for each file after your password changes.

[JdL42]

Thank's a lot for your answer (sorry for the delay). I'm afraid too. Perhaps I can try a solution like a function that connect to the SharePoint list once and extract all files I need. I don't kow if that could work. Will try.