Forum Discussion

saunders's avatar
saunders
Icon for Helper II rankHelper II
9 years ago
Solved

Filter Odata by measure or dax

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!

 

  • saunders's avatar
    saunders
    9 years ago

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

3 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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

    • saunders's avatar
      saunders
      Icon for Helper II rankHelper II
      9 years ago

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

    • coreyw's avatar
      coreyw
      Icon for Helper I rankHelper I
      9 years ago

      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?