Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

[not an IDEA but a BUG] PowerBI dIrectQuery to API endpoint performs unwanted warm-up calls

Summary:

Do not make the several pre-fetch calls to API endpoints for the Web.Contents method. Just grab the data.

 

Details:

When using PowerBI DirectQuery it performs 2-3 pre-fetch warm-up calls. Most like to see if the endpoint is alive and if alive has some data.

Similar syntax to below I am using:

 

GetCSVData = Web.Contents( "https://api.acme.com/v1/exports?order_id=ON-00000",........)

And it results in HTTP errors of 499 (client abort connection) and 502 (bad gateway) and eventually HTTP 200 (ok).

Screenshot 2021-10-21 at 11.40.11.png

Status: Investigating
Comments
v-robertq-msft
Community Support

Hi, 

If you want to get a solution for this kind of network issue in the Power BI as soon as possible, I suggest you to open a support ticket to ask the opinions from the technical support team of Microsoft about this issue.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

v-robertq-msft
Community Support
Status changed to: Investigating
 
HulstB
Frequent Visitor

No need for a support ticket... I prefer someone from the PowerBI server-side development team to look at the source code and the logic related to this behavior of contacting the API endpoint with the Web.Contents funtion.


I guess this "DirectQuery server-side" part of powerbi is not found in public github for me to investigate... 😉