cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rynelees Regular Visitor
Regular Visitor

Query the results of an OData query?

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?
5 REPLIES 5
Moderator v-yuezhe-msft
Moderator

Re: Query the results of an OData query?

@rynelees,


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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
rynelees Regular Visitor
Regular Visitor

Re: Query the results of an OData query?

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. 

nickchobotar Established Member
Established Member

Re: Query the results of an OData query?

@rynelees

 

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])

image.png

 

 

N -

 

rynelees Regular Visitor
Regular Visitor

Re: Query the results of an OData query?

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

nickchobotar Established Member
Established Member

Re: Query the results of an OData query?

@rynelees

 

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 -

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 220 members 2,049 guests
Please welcome our newest community members: