Failling to set up auto refresh

[Pablo_GNA]

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?

[christinepayton]

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. 

[aj1973]

Hi @Pablo_GNA 

If the Sharepoint is on cloud then you don't need a Gateway for it.

It all starts in the desktop, How do you connect to Sharepoint? can you explain step by step please?

[Pablo_GNA]

I'm using this line from Power Query: 
= SharePoint.Files("https://companyname.sharepoint.com/sites/data", [ApiVersion = 15])

[aj1973]

The connection Step before Power Query, it asks you to chose between 1.0 and 2.0

Chose 2.0 and try again 

[Pablo_GNA]

That happens when you connect using Sharepoint list, however I'm using the option to connect a Sharepoint folder becouse I'm reading all the .csv inside it

[aj1973]

Can you open Power Query and screenshot the M code and applied steps please?

[Pablo_GNA]

Somehow I could get a smaller error, at the moment I'm getting this:

Data source error {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provide has a null value. Data source type: SQL. Property name: Username. "}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: FacTable.

I have had to translate some lines in the error log, I hope it doesn't matter

[aj1973]

The problem is no longer Sharepoint! You have a problem connecting to SQL Server. Credentials