Codeunit 6327 Power BI Report Aggregator
src/Layers/W1/BaseApp/Modules/System/PowerBI/APIs/PowerBIReportAggregator.Codeunit.al197 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Integration.PowerBI;using System.Integration;/// <summary>/// Collects all reports that need uploading from all sources and provides a unified iterator./// </summary>codeunit 6327 "Power BI Report Aggregator"{ Access = Internal; var PowerBIServiceMgt: Codeunit "Power BI Service Mgt."; PendingSystemBlobs: List of [Guid]; PendingCustomerReports: List of [Guid]; PendingDeployableReports: List of [Integer]; SystemIndex: Integer; CustomerIndex: Integer; DeployableIndex: Integer; BlobDoesNotExistTelemetryMsg: Label 'Trying to upload a non-existing blob, with ID: %1.', Locked = true; PageIdEmptyForDeploymentTxt: Label 'Page ID for Power BI deployment is empty.', Locked = true; procedure LoadAllPending(Context: Text[50]): Boolean begin Clear(PendingSystemBlobs); Clear(PendingCustomerReports); Clear(PendingDeployableReports); SystemIndex := 0; CustomerIndex := 0; DeployableIndex := 0; LoadOutOfTheBoxReports(Context); LoadCustomerReports(); LoadDeployableReports(); exit((PendingSystemBlobs.Count() > 0) or (PendingCustomerReports.Count() > 0) or (PendingDeployableReports.Count() > 0)); end; procedure Next(var Report: Interface "Power BI Uploadable Report"): Boolean var SystemTableReport: Codeunit "Power BI System Table Report"; CustomerReport: Codeunit "Power BI Customer Report"; DeployableReportImpl: Codeunit "PBI Deployable Report Impl."; begin SystemIndex += 1; if SystemIndex <= PendingSystemBlobs.Count() then begin SystemTableReport.SetBlobId(PendingSystemBlobs.Get(SystemIndex)); Report := SystemTableReport; exit(true); end; CustomerIndex += 1; if CustomerIndex <= PendingCustomerReports.Count() then begin CustomerReport.SetReportId(PendingCustomerReports.Get(CustomerIndex)); Report := CustomerReport; exit(true); end; DeployableIndex += 1; if DeployableIndex <= PendingDeployableReports.Count() then begin DeployableReportImpl.SetReport(Enum::"Power BI Deployable Report".FromInteger(PendingDeployableReports.Get(DeployableIndex))); Report := DeployableReportImpl; exit(true); end; exit(false); end; procedure PendingCount(): Integer begin exit(PendingSystemBlobs.Count() + PendingCustomerReports.Count() + PendingDeployableReports.Count()); end; local procedure LoadOutOfTheBoxReports(Context: Text[50]) var PowerBIBlob: Record "Power BI Blob"; PowerBIReportUploads: Record "Power BI Report Uploads"; BlobId: Guid; begin Clear(PendingSystemBlobs); if Context = '' then begin Session.LogMessage('0000E1I', PageIdEmptyForDeploymentTxt, Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', PowerBIServiceMgt.GetPowerBiTelemetryCategory()); exit; end; BlobId := GetOutOfTheBoxBlobIdForDeployment(Context); if not GetPowerBIBlob(PowerBIBlob, BlobId) then exit; if not PowerBIReportUploads.Get(PowerBIBlob.Id, UserSecurityId()) then begin PendingSystemBlobs.Add(PowerBIBlob.Id); exit; end; if not (PowerBIReportUploads."Report Upload Status" in [ PowerBIReportUploads."Report Upload Status"::Completed, PowerBIReportUploads."Report Upload Status"::Skipped, PowerBIReportUploads."Report Upload Status"::PendingDeletion, PowerBIReportUploads."Report Upload Status"::Failed]) then PendingSystemBlobs.Add(PowerBIBlob.Id); end; local procedure LoadCustomerReports() var PowerBICustomerReports: Record "Power BI Customer Reports"; PowerBIReportUploads: Record "Power BI Report Uploads"; begin Clear(PendingCustomerReports); if PowerBICustomerReports.FindSet() then repeat if not PowerBIReportUploads.Get(PowerBICustomerReports.Id, UserSecurityId()) then PendingCustomerReports.Add(PowerBICustomerReports.Id) else if not (PowerBIReportUploads."Report Upload Status" in [ PowerBIReportUploads."Report Upload Status"::Completed, PowerBIReportUploads."Report Upload Status"::Skipped, PowerBIReportUploads."Report Upload Status"::PendingDeletion, PowerBIReportUploads."Report Upload Status"::Failed]) then PendingCustomerReports.Add(PowerBICustomerReports.Id); until PowerBICustomerReports.Next() = 0; end; local procedure LoadDeployableReports() var PowerBIDeployment: Record "Power BI Deployment"; UploadStatus: Enum "Power BI Upload Status"; begin Clear(PendingDeployableReports); // Only reports that have been selected for deployment will have a record in the "Power BI Deployment" table if not PowerBIDeployment.FindSet() then exit; repeat // Skip records whose enum ordinal is no longer defined (the defining extension may have been uninstalled) if Enum::"Power BI Deployable Report".Ordinals().Contains(PowerBIDeployment."Report Id".AsInteger()) then begin UploadStatus := PowerBIDeployment.GetUploadStatus(); // Only pick up reports that are not yet in a terminal state. // Version upgrades are handled explicitly via the Update action on the Deployments page. if not (UploadStatus in [ Enum::"Power BI Upload Status"::Completed, Enum::"Power BI Upload Status"::Skipped, Enum::"Power BI Upload Status"::PendingDeletion, Enum::"Power BI Upload Status"::Failed]) then PendingDeployableReports.Add(PowerBIDeployment."Report Id".AsInteger()); end; until PowerBIDeployment.Next() = 0; end; local procedure GetOutOfTheBoxBlobIdForDeployment(Context: Text[50]): Guid var PowerBIBlob: Record "Power BI Blob"; PowerBIDefaultSelection: Record "Power BI Default Selection"; IntelligentCloud: Record "Intelligent Cloud"; NullGuid: Guid; begin PowerBIDefaultSelection.Reset(); PowerBIDefaultSelection.SetFilter(Context, Context); if PowerBIDefaultSelection.IsEmpty() then exit(NullGuid); if PowerBIDefaultSelection.FindSet() then repeat PowerBIBlob.Reset(); PowerBIBlob.SetRange(Id, PowerBIDefaultSelection.Id); PowerBIBlob.SetRange("GP Enabled", IntelligentCloud.Get()); if not PowerBIBlob.IsEmpty() then exit(PowerBIDefaultSelection.Id); until PowerBIDefaultSelection.Next() = 0; PowerBIBlob.SetRange("GP Enabled", false); if PowerBIBlob.FindFirst() then exit(PowerBIBlob.Id); exit(NullGuid); end; local procedure GetPowerBIBlob(var PowerBIBlob: Record "Power BI Blob"; BlobId: Guid): Boolean begin if not IsNullGuid(BlobId) then if PowerBIBlob.Get(BlobId) then exit(true); Session.LogMessage('0000B61', StrSubstNo(BlobDoesNotExistTelemetryMsg, BlobId), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', PowerBIServiceMgt.GetPowerBiTelemetryCategory()); exit(false); end;}