Forum Discussion
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...
Same problem here. Pinging our internal REST API and Excel/PowerBI sends multiple requests. When the request is for an expensive query it effectively kills our server. We have the results set to stream so the server isn't overburdened, but when Excel/PowerBI sends a dozen requests that are abandoned, the queries are still executed and the pipes fill-up without offloading the data. The timeout option does nothing. This chews through our server's memory pretty quickly. This is a very frustarting problem. Is there any solution?