How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

Question

Hi,&nbsp;I want to specify a date range on a table column while exporting a report to pdf.&nbsp;I'm following the below article for exporting&nbsp;https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to&nbsp;&nbsp; var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration
            {
                Settings = new ExportReportSettings
                {
                    Locale = "en-us",
                },
                Pages = new List&lt;ExportReportPage&gt;(),
                ReportLevelFilters = new List&lt;ExportFilter&gt;() { new ExportFilter("DateTable/DateColumn ge 2022-05-07 and DateTable/DateColumn le 2022-06-07'") }
            };&nbsp;&nbsp;Please help me with the syntax.&nbsp;Thank you&nbsp;

neehar · Answer

I have even tried the below code but it is not working

 //ReportLevelFilters = new List<ExportFilter>() { new ExportFilter("DateTable/DateColumn lt '2022-05-13T00:00:00' and DateColumn gt '2022-05-10T00:00:00'") } //Not working

Please help

anonymous · Answer

HI&nbsp;Neehar,
You can try to use the full URL filter string in your request to ensure if it works:
&nbsp;
 ReportLevelFilters = new List&lt;ExportFilter&gt;() { 
    new ExportFilter("?filter=DateTable/DateColumn lt '2022-05-07' and DateTable/DateColumn gt '2022-06-07'") 
}
&nbsp;
In addition, you can also add a breakpoint to trace the request structure to check the concatenated request contents then you can modify the filter string based on these contents.
Regards,
Xiaoxin Sheng

neehar · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;I have tried to apply the filter using the above code snippet, but it is not working.ReportLevelFilters = new List&lt;ExportFilter&gt;() { new ExportFilter("?filter=DateTable/Date lt '01/20/2013' and DateTable/Date gt '01/04/2013'") }&nbsp;&nbsp;Thanks | Neehar&nbsp;&nbsp;

amoshersch · Answer

Neehar&nbsp;I believe you don't need to add the "?filter=" prefix.I am using something like&nbsp;ReportLevelFilters = new List&lt;ExportFilter&gt;() { new ExportFilter("Geo/Region eq 'East') };&nbsp;My suggestion - first try your filter in Power BI portal URL as described here:https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filtersAnd once you get it to work correctly it should work for you in the API (but without the "?filter=")

neehar · Answer

Hi,&nbsp;AmosHersch&nbsp;,Thanks for the reply, I've even tried removing the&nbsp;?filter. It didn't work&nbsp;with the date type column but works with the string type column.I tried the below syntax&nbsp;    //ReportLevelFilters = new List&lt;ExportFilter&gt;() { new ExportFilter("RandomData/Date lt '01/20/2013' and RandomData/Date gt '01/04/2013'") } //not working
    //ReportLevelFilters = new List&lt;ExportFilter&gt;() { new ExportFilter("RandomData/Date lt '01/20/2013' and Date gt '01/04/2013'") } //not working
    // ReportLevelFilters = new List&lt;ExportFilter&gt;() { new ExportFilter("RandomData/Date gt '01/04/2013'") } //not working
    //ReportLevelFilters = new List&lt;ExportFilter&gt;() { new ExportFilter("RandomData/Name eq 'Neehar'") } //Working&nbsp;Thanks | Neehar&nbsp;&nbsp;

Forum Discussion

How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

6 Replies

Related content

Microsoft.PowerBI.API issues - PowerBIReportExportConfiguration - MethodNotAllowed

During Power BI Export, How to Reset Default Report Filters Before Applying reportLevelFilters ?

reportLevelFilter not filtering when using Power BI REST API (ExportTo)

ReportLevelFilters is not working using PowerAutomate

exportToFile API with reportLevelFilters: Introduce support for Slicer filters and NotIn operator