Hi all,
We get access to power bi printing endpoint in the morning and then it stops, it varies when it stops, it never fails when we run it from Visual Studio.
The error is Operation returned an invalid status code 'Forbidden'.
Would really like to know if we are reaching a limit that we are not aware of.
Our customers have access to the reports on a continual basis, no problems.
We have ruled out our firewall rules.
We have a premium backed embedded service EM1 SKU.
We use a service principal account.
Fabric capacity metrics do not show any thresholds being exceeded ever.
The webapp runs in a secure network segment.
Embed Trial tokens is 0 but we have purchased an embedded SKU so don't see this is the issue
The code we use:
public static MemoryStream ExportPowerBIReport(
Guid WorkspaceId,
Guid ReportId,
string ExportName,
FileFormat ExportFileFormat,
string ExportFilter = "")
{
var exportRequest = new ExportReportRequest
{
Format = ExportFileFormat,
PowerBIReportConfiguration = new PowerBIReportExportConfiguration
{
DefaultBookmark = new PageBookmark {State = ExportFilter }
},
};
Export export = pbiClient.Reports.ExportToFileInGroup(WorkspaceId, ReportId, requestParameters: exportRequest);
string exportId = export.Id;
do
{
System.Threading.Thread.Sleep(5000);
export = pbiClient.Reports.GetExportToFileStatusInGroup(WorkspaceId, ReportId, exportId);
} while (export.Status != ExportState.Succeeded && export.Status != ExportState.Failed);
if (export.Status == ExportState.Succeeded)
{
var exportStream = pbiClient.Reports.GetFileOfExportToFileInGroup(WorkspaceId, ReportId, exportId);
var memoryStream = new MemoryStream();
exportStream.CopyTo(memoryStream);
return memoryStream;
}
return null;
}
Thanks for any help
Paul
