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...
Hi did you ever figure this out?
I get the the same thing with an MVC API. Power BI Desktop refresh hits the Web datasource multiple times.
Thanks,
Dax
Hi Dax,
I suspect it is a bug with Power BI Web Data Source as the repeated requests is much shorter than the Command Timeout value that is specified in the Advance option.
For the time being I am testing a workaround by implementing Varnish Cache Server for the REST API application.
It does help by reducing loading to the REST API applcation and responding to subsequent Power BI requests within seconds.
Problem is Varnish Cache Server does not support SSL and I hope Power BI will have a fix for this.
Best regards
Kin Kheong