cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vinS
Advocate II
Advocate II

Filter OData Feed URL to filter the Data from D365 Finance and OperationsURL at the source level

I have data from D365 F&O coming into a PowerBI report via a OData URL.
However the data coming in to the table has over 600,000+ records and increasing with every refresh. 
The number of records i need from this big table is only about 5000-10000 records. 
Hence I want to filter this table at the source level itself instead of bringing in all the records.
I found that by having a filter for the length of the important column [AccountDisplayValue] to be greater than 20 i can sharply reduce the data from 600,000+ to only 20,000 + rows. 
However when i input this into my source URL feed
"https://companyname.sandbox.dynamics.com/data/TableName?$filter=length(AccountDisplayValue) gt 16"
it does not work even though there is no syntax error in this source url.
Please Help.
My current refresh time goes to over 2 hours for this single table!

1 REPLY 1
vidyadutt
Helper II
Helper II

Hi @vinS, did you find a solution to this problem? I'm in a similar situation and I couldn't find the correct resource on this topic - yet.

 

Regards, Vidyadutt

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.