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

0 REPLIES 0

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.