Forum Discussion

Neehar's avatar
Neehar
Helper I
4 years ago

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...
Need Help
Show and Tell
Tutorial Requests
Neehar's avatar
Neehar
Helper I
4 years ago

Hi Anonymous ,

 

I have tried to apply the filter using the above code snippet, but it is not working.

ReportLevelFilters = new List<ExportFilter>() { new ExportFilter("?filter=DateTable/Date lt '01/20/2013' and DateTable/Date gt '01/04/2013'") } 

 

Thanks | Neehar 

 

AmosHersch's avatar
AmosHersch
Microsoft Employee
4 years ago

Neehar 

I believe you don't need to add the "?filter=" prefix.

I am using something like 

ReportLevelFilters = new List<ExportFilter>() { new ExportFilter("Geo/Region eq 'East') };

 

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-filters

And once you get it to work correctly it should work for you in the API (but without the "?filter=")

  • Neehar's avatar
    Neehar
    Helper I
    4 years ago

    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 

     

Related content