topic Re: How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ? in Developer

How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

Neehar — Mon, 27 Jun 2022 17:22:03 GMT

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/embedded/export-to

var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration { Settings = new ExportReportSettings { Locale = "en-us", }, Pages = new List<ExportReportPage>(), ReportLevelFilters = new List<ExportFilter>() { new ExportFilter("DateTable/DateColumn ge 2022-05-07 and DateTable/DateColumn le 2022-06-07'") } };

Please help me with the syntax.

Thank you

Re: How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

Neehar — Tue, 28 Jun 2022 13:26:01 GMT

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

Re: How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

Anonymous — Thu, 30 Jun 2022 01:59:34 GMT

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

Re: How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

Neehar — Tue, 05 Jul 2022 04:26:53 GMT

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

Re: How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

AmosHersch — Mon, 04 Jul 2022 10:49:49 GMT

@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=")

Re: How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

Neehar — Tue, 05 Jul 2022 04:33:11 GMT

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

Re: How to specify date range in PowerBIReportExportConfiguration ReportLevelFilters ?

AmosHersch — Tue, 05 Jul 2022 06:37:49 GMT

@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"