oData.Feed Performance Issue

[FrancescaBatt]

Dear Community,

We are developing a Power Query Custom connector based on oData.Feed source. We are doing some tests and  when we try to load data through oData.Feed source it seems that Power BI takes much longer (almost double) than executing the same oData API call externally or from other tools.
We would like to investigate to understand how to reduce this time, and understand exactly what are the operations performed. In background it seems that Power BI performs the same call to the server several times: in particular it apparently makes three unsuccessfull calls before it succeeds.
Could you please help us?

I've already tried with Power Query Diagnostics.

Thank you!

Francesca

[FrancescaBatt]

Hello,

Thank you for your reply. From our tests It seems that Power BI takes much longer than other BI tools and we tried with both oData.feed and Web source. Do you have any suggestions to improve performance?

Thank you

[lbendlin]

Check the network traces (wireshark or similar) to see where exactly the wait is happening.

Do you see an issue primarily with the authentication, or more with the data throughput?

[lbendlin]

That's unfortunately by design.  Power Query tries all kinds of meta data queries first before finally attempting to load the actual data.

Same general idea as this one:  Chris Webb's BI Blog: Why Is Power BI Running My SQL Query Twice? (crossjoin.co.uk)