Forum Discussion
Refresh not workfing in data model
Good day geniuses 🙂
Having issues with setting up a refresh. The refresh appears to be working, but runs for several minutes and then fails.
My data is connected via "Web" to a sharepoint file. Not sure if the "Configuration" is incorrect, but I've tried different options to no success. Please help.
 
You want to use OAuth 2 as the auth type, not anonymous--
3 Replies
You want to use OAuth 2 as the auth type, not anonymous--
As this is a file stored in SharePoint, it doesn't support being accessed with Anonymous auth. As christinepayton has mentioned, you need to select OAuth2. And don't check "Skip test connection". When you save the credentials of the data source, it will test this connection to validate the credentials for you.
Best Regards,
JingYou nailed it! Can't thank this community enough for all the knowledge shared.
