Forum Discussion

Grumelo's avatar
Grumelo
Advocate II
10 years ago

Don't use Odata!

Don't use OData Connector! Don't retrieve your data with OData.Feed()!   WHY ?   Because until it's fixed the OData connector is not at all doing what you are expecting. Data retrieval is slow ...
Show and Tell
Grumelo's avatar
Grumelo
Advocate II
10 years ago

This is what Power BI desktop is doing when using OData.Feed()

 

ResultProtocolURLBodyCachingContent-TypeProcess
200HTTPS/BI_Demo/_vti_bin/listdata.svc/$metadata113,170no-cacheapplication/xml;charset=utf-8microsoft.mashup.container.netfx40:9188
200HTTPS/BI_Demo/_vti_bin/listdata.svc/GreenWinerySalesBudget?$select=Budget,Id,WineType,Year23,969no-cacheapplication/atom+xml;charset=utf-8microsoft.mashup.container.netfx40:6636
200HTTPS/BI_Demo/_vti_bin/listdata.svc/GreenWinerySalesBudget?$select=WineType,Year,Budget813no-cacheapplication/json;charset=utf-8microsoft.mashup.container.netfx40:9188
200HTTPS/BI_Demo/_vti_bin/listdata.svc/GreenWinerySalesBudget?$select=WineType,Year,Budget813no-cacheapplication/json;charset=utf-8microsoft.mashup.container.netfx40:9188
200HTTPS/BI_Demo/_vti_bin/listdata.svc/GreenWinerySalesBudget?$select=WineType,Year,Budget22,700no-cacheapplication/atom+xml;charset=utf-8microsoft.mashup.container.netfx40:9188
200HTTPS/BI_Demo/_vti_bin/listdata.svc/GreenWinerySalesBudget?$select=WineType,Year,Budget813no-cacheapplication/json;charset=utf-8microsoft.mashup.container.netfx40:6636
200HTTPS/BI_Demo/_vti_bin/listdata.svc/GreenWinerySalesBudget?$select=WineType,Year,Budget813no-cacheapplication/json;charset=utf-8microsoft.mashup.container.netfx40:6636
200HTTPS/BI_Demo/_vti_bin/listdata.svc/GreenWinerySalesBudget?$select=WineType,Year,Budget22,700no-cacheapplication/atom+xml;charset=utf-8microsoft.mashup.container.netfx40:6636
arify's avatar
arify
Microsoft Employee
10 years ago

Hi Grumelo,

 

Can you please send us a frown with the Fiddler traces?

 

Thanks

    • arify's avatar
      arify
      Microsoft Employee
      10 years ago

      Thanks, we'll take a look at it and will let you know :)

      • Grumelo's avatar
        Grumelo
        Advocate II
        10 years ago

        By the way, this issue of calling many time the data source is not limited to OData.feed(); same kind of problem with XML.Document(); I've noticed at least two calls instead of one.

         

        And in Query edit mode it's even worst.