Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to 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 ?
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 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 ?
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |