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

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

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

Capture.PNG

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

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

Hi @martinmcmillz,

 

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? Smiley Happy

"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

View solution in original post

2 REPLIES 2
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

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

Hi @martinmcmillz,

 

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? Smiley Happy

"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

View solution in original post

martinmcmillz Regular Visitor
Regular Visitor

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

Thank you for your response.

 

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and 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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 333 members 3,295 guests
Please welcome our newest community members: