Timeout limit for Web- DataSource.Error: This function doesn't support the query option 'Timeout'

[Anonymous]

Hi,

i have beeen facing timeout error when connecting to web data source (rather small data size, about 2000 rows x 15 columns). When i have reduced the rows to about 100, then it worked.

I have followed the suggestions to increase the timeout limit, using the code 

Source = Web.BrowserContents("https://.....",[Timeout=#duration(0,0,15,0)]),

But facing following error:

DataSource.Error: Web.BrowserContents: This function doesn't support the query option 'Timeout' with value '#duration(0, 0, 15, 0)'.
Details:
0.00:15:00

Any suggestion how to overcome this error or some other suggestion how to increase the timeout limit are really appreciated.

Side question: what is the general limitaion in terms of size (MB) or nubmer of rows/colums for web data source?

Many Thanks, František

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

Did you follow the suggestion in this case to set the timeout for the web data source?

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/m-p/53459

According to my research, it seems that the error occurs in your “Web.BrowserContents” function because the solution, in that case, uses the “Web.Page” and “Web.content” to link to the web data source, you can also change the M code in your advanced editor to follow the solution and check if it can work.

More info about these three accessing web data function in M language:

Web.BrowserContents

Web.Contents

Web.Page

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thx, but pagination did not help.

[amitchandak]

@Anonymous , You might have to remove that timeout.

refer if the pagination can work with web source

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78