Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Microsoft.PowerBI.API issues - PowerBIReportExportConfiguration - MethodNotAllowed

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.

  • 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.

3 Replies

  • AmosHersch's avatar
    AmosHersch
    Microsoft Employee

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thank you, AmosHersch,

     

    Upgrading to Gen2 has resolved my issue.

  • S19K15's avatar
    S19K15
    Regular Visitor

    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.