CommandTimeout for Sharepoint folder

[gk2go]

let Source = Sql.Database("myserver.database.windows.net", "AdventureWorks", [CommandTimeout=#duration(0, 2, 0, 0)]),

Does this work with Sharepoint folders also? Or is there another command for Sharepoint connections?

When I try I get: 

Expression.Error: 'CommandTimeout' isn't a valid SharePoint option. Valid options are:
ApiVersion

Alternatives?

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#query-timeouts

[v-frfei-msft · Accepted solution]

Hi @gk2go ,

Based on my test, It is not supported yet for sharepolint folder connector. We can use Odata feed to work around like that.

let
    Source = OData.Feed("https://xxxxx.sharepoint.com/_vti_bin/listdata.svc", null, [Implementation="2.0"],[Timeout=#duration(0, 0, 15, 0)]),
    MP3_table = Source{[Name="MP3",Signature="table"]}[Data]
in
    MP3_table

[gk2go]

This didn't work: Expression.Error: The 'Timeout' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer