Forum Discussion

Geoffrey Estrade's avatar
Geoffrey Estrade
Copper Contributor
Feb 15, 2018
Solved

WebAPi Query Timeout

Hi everyone, I'm using Get and Transform Data to get data from my webapi. If the amount of data is big and the job is hard, the webapi can take few minutes to response Excel. The problem is about 1...
BI & Data Analytics
Need Help
  • Geoffrey Estrade's avatar
    Geoffrey Estrade
    Feb 16, 2018

    Ok I found a the solution. The first time I create the query, I can set the timeout in advanced settings window.

     

    For an existing query, I can add the timeout with the advanced editor

    Source = Json.Document(Web.Contents("http://172.17.8.102/swa/api/trendquery", [Timeout=#duration(0, 0, 5, 0)])),
Geoffrey Estrade's avatar
Geoffrey Estrade
Copper Contributor
Feb 16, 2018

Ok I found a the solution. The first time I create the query, I can set the timeout in advanced settings window.

 

For an existing query, I can add the timeout with the advanced editor

Source = Json.Document(Web.Contents("http://172.17.8.102/swa/api/trendquery", [Timeout=#duration(0, 0, 5, 0)])),

Resources