I have few paginated reports in my Power BI Premium.
Opening the report, put the parameters, viewing the report(around 16 rows) took about 5 secondsm and exporting it as a pdf manually takes around another 5 seconds.
I created an dotnet funtion app to automate this process. For each report, it took around 40 seconds to get the exportId (by calling this method, _powerBiClient.Reports.ExportToFileAsync(groupId, reportId, exportReportRequest)), and totally around 100 seconds to get the file stream.
Is there any way to speed it up?
Thanks,
Xiaojun Xie
// This step took around 40 seconds
var export = await _powerBiClient.Reports.ExportToFileAsync(groupId, reportId, exportReportRequest);
stopwatch.Stop();
var elapsedTime = stopwatch.ElapsedMilliseconds;
Console.WriteLine(elapsedTime);
var exportId = export.Id;
HttpOperationResponse<Export> httpMessage = null;
Export exportStatus = null;
var startTime = DateTime.UtcNow;
const int c_secToMillisec = 1000;
do
{
if (DateTime.UtcNow.Subtract(startTime).TotalMinutes > 5)
{
// Error handling for timeout and cancellations
return null;
}
exportStatus = await _powerBiClient.Reports.GetExportToFileStatusAsync(groupId, reportId, exportId);
}
// While not in a terminal state, keep polling
while (exportStatus.Status != ExportState.Succeeded && exportStatus.Status != ExportState.Failed);
if (exportStatus.Status != ExportState.Succeeded)
{
// Error, failure in exporting the report
return null;
}
var fileStream = await _powerBiClient.Reports.GetFileOfExportToFileAsync(groupId, reportId, export.Id);
total.Stop();
var time = total.ElapsedMilliseconds;
Console.WriteLine($"Total: {filename} ---- {time}");
return new ExportedFile
{
FileStream = fileStream,
FileSuffix = export.ResourceFileExtension,
Filename = filename
};
