Forum Discussion

lgrasset's avatar
lgrasset
New Member
9 years ago

Project Online - Odata Feed with $select

Hi,   I'm trying to build an OData service onto our Cloud data manager to make our financial data available into Power BI. Basically, our data models are described by star schema - each fact is id...
lgrasset's avatar
lgrasset
New Member
9 years ago

Hi,

 

Thanks for your answer.

 

To make it clear, I've created a minimal OData service to illustrate my issue.

You can find the service at url http://devel.inativ.fr/odata/dbg and the metadata at http://devel.inativ.fr/odata/dbg/$metadata.

 

if you use this url in your browser, you'll get a synthetic json with only 3 properties.

http://devel.inativ.fr/odata/dbg/FACT?$select=CLOSING,COMPANY,AMOUNT&$filter=ACCOUNT%20eq%20'R70100'%20and%20PARTNER%20not%20eq%20null

 

The same url pasted in Power BI OData connector will give you all extra properties set to null.

 

How do I avoid Power BI to add these empty properties ?

 

kmescha's avatar
kmescha
Frequent Visitor
9 years ago

Not sure if this is related or not but I'm having a similar issue with an OData query from PowerBI behaving very different than if I run it straight from the browser. Via a trace using Fiddler here is what I'm seeing.

 

If I run a select from the browser it makes one OData call to the API and I get the expected results in 2 seconds or less for a decent size data set of over 1000 records across 10 fields.

 

If I run that same OData call from a data set in PowerBI 16 calls are made to the API and in 3 calls captured it makes a call to /api/data/v8.2/$metadata and that call takes 20 seconds each time it runs. So I'm over 1 minute to get the same results in PowerBI. 

 

Not sure why PowerBI has to make all these extra calls to accomplish pulling the same data.

  • vpossoz's avatar
    vpossoz
    New Member
    9 years ago

    I have exactly the same issue!

     

    PowerBI does an insane amount of calls to the OData feed. In my scenario we have a dashboard that uses many feeds and in PBi we have connected the feed data to each others in order to create the reports we need. It looks like PowerBi is calling the OData feed for every single relationship in which it is used. We get the same feed called 32 times in rapid succession which is crippling the data server, especially because we have about 10 dashboards setup using the same query with different custonmer filters. A couple of days ago PBI requested a total of 768 requests! at 500k rows and 20mb each! totally inaceptable.

     

    Basically PBI actually gets the feed data rather than just getting the meta data when rebuilding the object model internally.

    That's pretty rubbish.