cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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

2 REPLIES 2
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

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
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 249 members 3,052 guests
Please welcome our newest community members: