Filter data from ODATA source prior to loading it in Power BI

[DanielCarvalho]

Hello community,

I am having an issue where I have data with millions of lines and sometimes I want to create a Power BI report based on, for example, a specific country (basically it should only load the data relative to that country) and if I use power query to do this he will have to load the data and then filter to that country, but I dont want to every time load mbs of data and have it look through millions of rows.

Is there a way to this? From my research I saw there is a paid odata connector but that is third party and as I have sensity information I required a way of doing this without passing data through a different source.

[rohit_singh · Accepted solution]

Hi @DanielCarvalho ,

You can filter Odata connections at source by using a $filter condition in the query string. Please refer the documentation below:
https://learn.microsoft.com/en-us/odata/concepts/queryoptions-overview

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[alexbjorlig]

I'm both a Power BI and software developer. I added the $filter as described in the link, but when I monitor the API the $filter seems to be removed from the query.

Did anyone find a solution, that works?

[DanielCarvalho]

Thanks for the quick reply, going to try this and see if it solves my issues, going to accept it as a solution meanwhile !! 

Kind regards,

Daniel