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

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's avatar
Anonymous
Not applicable
4 years ago

HI Neehar,

You can try to use the full URL filter string in your request to ensure if it works:

 

 ReportLevelFilters = new List<ExportFilter>() { 
    new ExportFilter("?filter=DateTable/DateColumn lt '2022-05-07' and DateTable/DateColumn gt '2022-06-07'") 
}

 

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