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

Anonymous — Wed, 22 May 2019 22:36:06 GMT

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!

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

Anonymous — Wed, 27 Jan 2021 13:02:01 GMT

Hi Anonymous, 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

topic Re: Filter OData Feed URL to filter the Data from D365 Finance and OperationsURL at the source level in Report Server

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

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