Importing Data from OData URL but applying a filter on dynamic date before I do

[Anonymous]

Hi Community

I've been scratching my head trying to understand how I can edit a query to get data from an OData source but apply a filter to one of the fields before it does. I only need the last 3 years worth of data to be downloaded but I have a lot more than that available to me. When I bring in the table as it is it's 140MB's worth, which doesn't seem like much but I'll also be bringing in other queries from other tables the total wait time to load my dataset would be way too long.

This is the URL and the tables I can currently access...

I know I can add /WS_Vendor_Ledger_Entries to the end of the feed to access it directly, but then I'll have to wait a very long time for the table to load before applying a filter. So perhaps it's at this point that we could do something to limit the amount of data coming through...any ideas?

Thanks in advance

Martin

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

Here is a similar thread in which some explanations are mention on this issue. Could you go to check if it helps in your scenario? 

"OData filter are not supported in Power BI

I know it’s working in PBI Desktop, but it will break on the service.

The solution is to Filter from the Power Query editor that generate a call to the function Table.SelectRows:

https://msdn.microsoft.com/en-us/library/mt260810.aspx

As to RequiresFilter and RequiredProperties, we don’t currently have any plans to support those. Please file a feature request at ideas.powerbi.com so that we can track interest."

---

Regards

[Anonymous]

Thank you for your response.