cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vinS Frequent Visitor
Frequent Visitor

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!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 142 members 2,179 guests
Please welcome our newest community members: