Forum Discussion
sanjeevgaut
5 years agoFrequent Visitor
Reports - Export To File , with filter options and pageName not working
Hi
I am trying to export report , with applied filter and for some page. i am getting error "Operation returned an invalid status code 'BadRequest'"
Below is my code.
var urlFilter = "Distry=CMC";
ExportReportPage pages1w3 = new ExportReportPage("ReportSection0");
IList<ExportReportPage> pageNames = new List<ExportReportPage> { pages1w3 };
var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration
{
Settings = new ExportReportSettings
{
Locale = "en-us",
},
// Note that page names differ from the page display names
// To get the page names use the GetPages REST API
Pages = pageNames,
// ReportLevelFilters collection needs to be instantiated explicitly
ReportLevelFilters = !string.IsNullOrEmpty(urlFilter) ? new List<ExportFilter>() { new ExportFilter(urlFilter) } : null,
};
var exportRequest = new ExportReportRequest
{
Format = FileFormat.ACCESSIBLEPDF,
PowerBIReportConfiguration = powerBIReportExportConfiguration,
};
var export = client.Reports.ExportToFile(ReportId, exportRequest);
Any help appreated..
3 Replies
- lbendlinSuper User
You have to use the report page ID, not the name. Use the API sandbox to test your API calls.
Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Docs
- sanjeevgautFrequent Visitor
lbendlin thanks for your response. I am able to get single page. but filtering is not applying..Any suggestions.. I want to apply multiple filter options.
- lbendlinSuper User
Currently you can only supply ONE report level filter.