Microsoft.PowerBI.API issues - PowerBIReportExportConfiguration - MethodNotAllowed

[Anonymous]

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.

[S19K15]

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.

[Anonymous]

Thank you, AmosHersch,

Upgrading to Gen2 has resolved my issue.

[AmosHersch · Accepted solution]

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.