Forum Discussion
Helper IIIFilter data from ODATA source prior to loading it in Power BI
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.
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-overviewKind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
3 Replies
rohit_singhSolution Sage
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-overviewKind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
DanielCarvalhoThanks 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
- alexbjorlig
Helper IV
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?
