Forum Discussion

edgreg's avatar
edgreg
Regular Visitor
7 years ago
Solved

URL filtering by date is broken

Trying to follow the documentation here and add some filters on my URL and having trouble getting date based filters working. I've gotten string based filters working using the eq operator, but I can...
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi edgreg,

    I have tested with below format and it could work, I suggest you test again. 

    ?filter=Table/Date gt datetime'2018-09-27T09:55:00'

    Regards,

    Daniel He

edgreg's avatar
edgreg
Regular Visitor
7 years ago

Did you try other operators other than eq?

 

As I mentioned in my post, the eq operator does appear to work. It's the other operators (gt/lt/ge/le) that do not appear to work correctly.

 

I cannot access your report to test...I get an error stating "Sorry, we couldn't find that report". I believe this is caused by the "me" portion of the URL https://app.powerbi.com/groups/me/reports/cf91650f-9248-40c6-b08a-317a64a011ec/ReportSection?filter=Table1/Date eq 2018-01-01. I believe me should be a guid.

 

 

 

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi edgreg,

Based on my test, with below code, it could also work on my side:

https://app.powerbi.com/groups/me/reports/cf91650f-9248-40c6-b08a-317a64a011ec/ReportSection?filter=Table1/Date gt 2018-01-01

Result:

I think it may due to your code with your date, could have tried with the below code again?

?filter=Builds/szEndTime gt 2018-10-03 15:00:00

Regards,

Daniel He

 

  • edgreg's avatar
    edgreg
    Regular Visitor
    7 years ago

    Hi Daniel,

     

    Nope, adding the below did not fix my issue:

    ?filter=Builds/szEndTime gt 2018-10-03 15:00:00

     

    Interesting that leavig the time off does work:

    ?filter=Builds/szEndTime gt 2018-10-09

     

    How can I get the time portion to work correctly?

     

    Thanks,
    Ed

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      Hi edgreg,

      I have tested with below format and it could work, I suggest you test again. 

      ?filter=Table/Date gt datetime'2018-09-27T09:55:00'

      Regards,

      Daniel He

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      Hi edgreg,

      Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

       

      Regards,

      Daniel He