Forum Discussion
kinkheong
9 years agoNew Member
Multiple requests for a single Get Data and Refresh Data with Web Data Source
It seem like for a single Web Data Source query Power BI Desktop is issuing a number of requests for the URL and the number of requests for the URL for a single query increases as the records to be r...
dpiret
8 years agoHelper I
Same here. Power BI with Excel, calling a RESTful API method that returns a JSON object that takes long (three minutes) to respond.
It looks like Power Query gets nervous and sends several times the same request, making things worse.
The M query is like this
= Json.Document(Web.Contents("http://domain.com/endpoint",[Timeout=#duration(0,2,0,0)]))
aduval
7 years agoNew Member
dpiret, did you get a resolution to this issue? I am also seeing multiple requests (three) every time I try to refresh a certain query and then it is timing out but continuing to send requests even after that. This is over taxing the server resources with the multiple calls.
- Robinsedlaczek7 years agoNew Member
Same here. Are there any solutions to this now???