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.
I have a dataset with all data from many SharePoint lists, all workig fine using Oauth2 as permissions/credentials.
We have one excel sheet saved on the same SharePoint site as an Excel document. It is connecting as web instead of sharepoint (not sure why, but that was what it did). It also used Oauth2 on desktop.
When I go to BI online and setup refreshes it is saying I dont have right credentials for the Web portion.
I checked and there is no OAuth2 option listed for it.
I need this updated ASAP because we have to automate these refreshes for many departments.
Thank you
Hi @Anonymous ,
When you are connecting with excel in sharepoint by web, please sign in with organizational account to have a try:
And also set the credential in service:
Regards,
Daniel He
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |