cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Power BI Hammering REST Web service

For approx. 50 REST targets generated by previous functions, I have a Power BI function that evaluates:

 

  = Json.Document( Web.Contents ( [href] ), 65001)

 

Power BI is making 3 requests per row, executing the REST query 150 times.  Server profiling shows that requests are coming about 2 to 5 ms apart from one another.  Phase next of the project will evaluate about 10K rows, and at 3x query duplication, this makes Power BI non-viable.  

 

I assume this is either a bug or an evaluation side-effect.  How can I get around Power BI hammering the server with back-to-back identical queries?

2 REPLIES 2
Community Support Team
Community Support Team

Re: Power BI Hammering REST Web service

Hi @Anonymous ,

Based on my test, the Web.Contents method will not make multiple requests, in your scenario, I would suggest you opening a ticket at https://powerbi.microsoft.com/en-us/support/.

Support Ticket.gif

Best Regards,

Teige

Anonymous
Not applicable

Re: Power BI Hammering REST Web service

In my scenario, the issue shows itself across several but not all PBI projects.  If others have had the same issue, a workaround would be helpful.  In the mean time, I will file a ticket and hope for the best.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors