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 all
After I got in contact with Microsoft, they provided a solution for me which works!
Solution:
Excel.Workbook(Binary.Buffer(Web.Contents("http://....
Microsoft:
"Binary.Buffer streams out in memory the binary content passed into the function which avoids subsequent M code (depending on the functions used) to generate additional calls for the same binary content (PromoteHeaders in your Mquery)."
I hope this helps you as well.