Forum Discussion
Failling to set up auto refresh
Hello lads,
I have a workspace which connects to 4 data sources, 3 SQL DB using gateaways which works perfectly and a sharepoint folder which apparently is failling to refresh.
This is the error
This is how the cofig tab looks like, as you can see the SQL connection works perfectly (in either case, desktop and service)
To connect the sharepoint I'm using a my company admin account which works for desktop but fail for service.
I have tried to create a gatewawy for share point using OAuth 2.0 as autentication method but it doesn's wotk despite the fact that the connection is working.
The connection is live but the refresh still failling, with the same error.
I have read the doc and similar issues, however nothing works, any suggestion?
8 Replies
I'm using this line from Power Query:
= SharePoint.Files("https://companyname.sharepoint.com/sites/data", [ApiVersion = 15])- aj1973
Community Champion
The connection Step before Power Query, it asks you to chose between 1.0 and 2.0
Chose 2.0 and try again
- christinepayton
Most Valuable Professional
You don't need to use the gateway if it's SharePoint Online, but you DO need to enter credentials in the scheduled refresh settings. It's in a section below the gateway settings. If you're using a service account, make sure it has permission to access the SharePoint sources - even an admin account will not have access to content by default in SharePoint unless it's explicitly shared.
