Query the results of an OData query?

[Anonymous]

Hello,

I have an OData feed that is getting too big. I already select and filter, but I was wondering if it’s possible to do something like query to count the rows of an OData feed. Or manipulate the OData results more than select and filter. Any tips or suggestions?

[nickchobotar]

@Anonymous

Back to your initial question. Yes. you can query OData and get row counts. Add a custom column and run this function against your feed.

Table.RowCount([Data])

N -

[Anonymous]

Does this happen before the Odata load? Can you filter the function?

[nickchobotar]

@Anonymous

Yes, you get the row count on the binary image - all those tables are not physically loaded into the model. Not sure what do you mean by "Can you filter the function?"

N -

[v-yuezhe-msft]

@Anonymous,

What OData service  do you connect to? Do you add select and filter parameters in the OData URL to limit the imported rows? 

Regards,
Lydia

[Anonymous]

Yes to both. At this point, I'm only downloading the data I need. I did realize after I posted this that I can group the results which helps, but it would be really nice to do this before the data gets into BI to further improve performance.