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?
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.