Refresh not workfing in data model

[Godislove22222]

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. 

 

[Godislove22222]

You nailed it! Can't thank this community enough for all the knowledge shared. 

[v-jingzhan-msft]

Hi @Godislove22222 

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,
Jing

[christinepayton · Accepted solution]

You want to use OAuth 2 as the auth type, not anonymous--