The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to 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.
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.
Thank you, AmosHersch,
Upgrading to Gen2 has resolved my issue.
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.