Filter Odata by measure or dax

[saunders]

Hi all,

Does anyone know how to add query options to an Odata feed using Dax?  

I want to filter rows in a feed like:

Latest_rows = OData.Feed("<OdataURL>?$filter=<OdataURLDateColumn>+gt+MAX('AnotherTable'[DateColumn])

New rows get added daily to the table in the Odata URL.  On a daily basis, I only want to import rows that haven't yet been imported, i.e. rows added later than those imported previously.  I can't work out how to build a dynamic Odata URL that filters  based on max date in the same or different table.

Any ideas much appreciated!

[v-haibl-msft]

@saunders

I don’t think it is possible to do it. We can only use DAX to filer after we get all data. Maybe these two ideas are what you desired.

Best Regards,

Herbert

[coreyw]

@v-haibl-msftWow, that can be devastating if you have millions of records server side.  There is no way to tell the server to filter in just what you need?

[saunders · Accepted solution]

Thanks Herbert, I was hoping someone might have a solution.