Forum Discussion

Grumelo's avatar
Grumelo
Icon for Advocate II rankAdvocate 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
Icon for Advocate II rankAdvocate 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
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi Grumelo,

 

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

 

Thanks

    • arify's avatar
      arify
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

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

      • Grumelo's avatar
        Grumelo
        Icon for Advocate II rankAdvocate 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.