topic Re: Microsoft.PowerBI.API issues - PowerBIReportExportConfiguration - MethodNotAllowed in Developer

Microsoft.PowerBI.API issues - PowerBIReportExportConfiguration - MethodNotAllowed

Juniorflip — Mon, 09 May 2022 16:12:40 GMT

Good morning all,

On Wednesday, 5/4, our API report generator started returning Microsoft.Rest.HttpOperationException: Operation returned an invalid status code 'MethodNotAllowed' when we are requesting an ExportID. The script that we are using below is what is running.

private static async Task<string> PostPowerBIExportRequest(Guid groupId, Guid reportId, PowerBIClient client) { Console.WriteLine("The PowerBI Export Request has fired."); var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration { Settings = new ExportReportSettings { Locale = "en-us", }, }; var exportRequest = new ExportReportRequest { Format = FileFormat.PDF, PowerBIReportConfiguration = powerBIReportExportConfiguration, }; try { var export = await client.Reports.ExportToFileInGroupAsync(groupId, reportId, exportRequest); return export.Id; } catch (Exception e) { Console.WriteLine("PowerBIExportConfiguration step has failed."); Console.WriteLine(e.ToString()); return "Failure"; } }

Please let me know what steps to take to remedy this outage.

Thank you,

J.R.

Re: Microsoft.PowerBI.API issues - PowerBIReportExportConfiguration - MethodNotAllowed

AmosHersch — Mon, 09 May 2022 18:30:53 GMT

Hi,

Exporting a report using the API is not supported on Gen1 capacities anymore. I assume this is why you started getting the error.

Please try upgrading your capacity to Gen2, or assign the workspace to a different capacity which is Gen2.

Re: Microsoft.PowerBI.API issues - PowerBIReportExportConfiguration - MethodNotAllowed

Juniorflip — Mon, 16 May 2022 14:58:52 GMT

Thank you, AmosHersch,

Upgrading to Gen2 has resolved my issue.

Re: Microsoft.PowerBI.API issues - PowerBIReportExportConfiguration - MethodNotAllowed

S19K15 — Wed, 14 Aug 2024 11:09:25 GMT

Even you are running on Gen2, it will not work if you have set workspace with "Large Semantic Model" which you can select if workspace is in a capacity.