Forum Discussion
Regarding URL filters
PoovigaS Please refer the below documentation on how to filter for dates using the url
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#date-data-typesOData V4 format: filter=Table/Date gt 2019-05-20 OData V3 format: filter=Table/Date gt datetime'2019-05-20T00:00:00'Appreciate a Kudos !
Thanks,
Jai
I'm embedding a Power BI report in a custom application and applying filters via URL parameters — not using the ?filter query string directly. I parse the parameters and apply filters during report rendering using the Power BI JavaScript API.
Filtering works fine for text columns, but I'm having trouble applying filters to date columns. Here's what I've tried:
- Is there a specific format expected for date values in embedded filters?
- Does Power BI apply any internal transformation (e.g., rounding or averaging) for date picker columns?Are there known issues with filtering on Date/Time columns using IAdvancedFilter?
Any insights or suggestions would be greatly appreciated!
What' not working:
1) ?table=Agent Status&column=Agent Date&values=2025-09-02,2025-09-06&type=date-range
2) ?table=Agent Status&column=Agent Date&values=datetime'2025-09-02T00:00:00',datetime'2025-09-06T00:00:00'&type=date-range
What's working:
?table=Agent Status&column=Agent Name&values=CSR - Ashamad
Super UserPoovigaS Please refer the below documentation on how to filter for dates using the url
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#date-data-types
OData V4 format: filter=Table/Date gt 2019-05-20
OData V3 format: filter=Table/Date gt datetime'2019-05-20T00:00:00'
Appreciate a Kudos !
Thanks,
Jai