Forum Discussion
How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?
Hi, I want to specify a date range on a table column while exporting a report to pdf. I'm following the below article for exporting https://docs.microsoft.com/en-us/power-bi/developer/emb...
Hi, AmosHersch ,
Thanks for the reply, I've even tried removing the ?filter. It didn't work with the date type column but works with the string type column.
I tried the below syntax
//ReportLevelFilters = new List<ExportFilter>() { new ExportFilter("RandomData/Date lt '01/20/2013' and RandomData/Date gt '01/04/2013'") } //not working
//ReportLevelFilters = new List<ExportFilter>() { new ExportFilter("RandomData/Date lt '01/20/2013' and Date gt '01/04/2013'") } //not working
// ReportLevelFilters = new List<ExportFilter>() { new ExportFilter("RandomData/Date gt '01/04/2013'") } //not working
//ReportLevelFilters = new List<ExportFilter>() { new ExportFilter("RandomData/Name eq 'Neehar'") } //Working
Thanks | Neehar
Neehar asking again - does the same date filter work for the same report when appended to the URL in Power BI portal?
Did you read here: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#date-data-types ?
Sounds like it worth trying something like: "RandomData/Date gt 2013-01-20"