Page 6322 Power BI WS Report Selection

Base Application, System.Integration.PowerBI

src/Layers/W1/BaseApp/Modules/System/PowerBI/Embedding/PowerBIWSReportSelection.Page.al386 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.Integration.PowerBI;using System.Environment;page 6322 "Power BI WS Report Selection"{    Caption = 'Power BI Reports Selection';    DeleteAllowed = false;    InsertAllowed = false;    LinksAllowed = false;    PageType = List;    SourceTable = "Power BI Selection Element";    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(ElementsRepeater)            {                IndentationColumn = IndentationValue;                IndentationControls = Name;                ShowAsTree = true;                Visible = HasReports and not IsErrorMessageVisible;                field(Name; Rec.Name)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Name';                    Editable = false;                    ToolTip = 'Specifies the name of the Power BI report or workspace.';                    StyleExpr = IndentationValue = 0;                    Style = Strong;                    trigger OnDrillDown()                    begin                        if Rec.Type <> Rec.Type::"Report" then                            exit;                        // Event handler for when the user clicks the report name hyperlink. This automatically selects                        // and enables the report and closes the window, so the user immediately sees the clicked report                        // on the parent page.                        Rec.Enabled := true;                        // OnDrillDown returns a LookupCancel Action when the page closes.                        // IsPgclosedOkay is used to tell the caller of this page that inspite of the LookupCancel                        // the action should be treated like a LookupOk                        IsPgClosedOkay := true;                        SaveAndClose();                    end;                }                field(ID; Rec.ID)                {                    ApplicationArea = Basic, Suite;                    Caption = 'ID';                    Editable = false;                    Visible = ShowAdditionalFields;                    ToolTip = 'Specifies the ID of the Power BI report or workspace.';                }                field(Type; Rec.Type)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Type';                    Editable = false;                    Visible = ShowAdditionalFields;                    ToolTip = 'Specifies the type of the line (e.g. workspace or report).';                }                field(WorkspaceID; Rec.WorkspaceID)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Workspace ID';                    Editable = false;                    Visible = ShowAdditionalFields;                    ToolTip = 'Specifies the ID of the workspace that this record is in (if the record is a workspace, this is the same as the ID).';                }                field(WorkspaceName; Rec.WorkspaceName)                {                    ApplicationArea = Basic, Suite;                    Caption = 'Workspace Name';                    Editable = false;                    Visible = ShowAdditionalFields;                    ToolTip = 'Specifies the name of the workspace that this record is in (if the record is a workspace, this is the same as the Name).';                }                field(Enabled; Rec.Enabled)                {                    ApplicationArea = Basic, Suite;                    ToolTip = 'Specifies that this report is enabled to be shown in the given page. This field has no effect for workspaces.';                    Enabled = IndentationValue <> 0;                }            }            group(NoAvailableReportsGroup)            {                ShowCaption = false;                Visible = not HasReports and not IsErrorMessageVisible;                label(NoReportsError)                {                    ApplicationArea = Basic, Suite;                    Caption = 'There are no reports available from Power BI.';                    ToolTip = 'Specifies that the Power BI APIs did not return any report to show.';                }            }            group(ErrorMessageGroup)            {                ShowCaption = false;                Visible = IsErrorMessageVisible;                field(ErrorMessage; ErrorMessageText)                {                    ApplicationArea = All;                    Editable = false;                    ShowCaption = false;                    ToolTip = 'Specifies an error that occurred.';                }            }        }    }    actions    {        area(reporting)        {            action(EnableReport)            {                ApplicationArea = All;                Caption = 'Enable';                Enabled = not Rec.Enabled and (Rec.Type = Rec.Type::"Report");                Gesture = LeftSwipe;                Image = "Report";                Scope = Repeater;                ToolTip = 'Enables the report selection.';                trigger OnAction()                begin                    Rec.Enabled := true;                    CurrPage.Update();                end;            }            action(DisableReport)            {                ApplicationArea = All;                Caption = 'Disable';                Enabled = Rec.Enabled and (Rec.Type = Rec.Type::"Report");                Gesture = RightSwipe;                Image = "Report";                Scope = Repeater;                ToolTip = 'Disables the report selection.';                trigger OnAction()                begin                    Rec.Enabled := false;                    CurrPage.Update();                end;            }            action(MyOrganization)            {                ApplicationArea = All;                Caption = 'Organizational Apps';                Image = PowerBI;                ToolTip = 'Browse apps that other people in your organization have published.';                Visible = IsSaas;                trigger OnAction()                begin                    HyperLink(PowerBIServiceMgt.GetContentPacksMyOrganizationUrl());                end;            }            action(Services)            {                ApplicationArea = All;                Caption = 'Marketplace Apps';                Image = PowerBI;                ToolTip = 'Browse available apps from Marketplace.';                Visible = IsSaas;                trigger OnAction()                begin                    HyperLink(PowerBIServiceMgt.GetContentPacksServicesUrl());                end;            }#if not CLEAN27            action(CleanDeployments)            {                ApplicationArea = All;                Caption = 'Default Reports';                Image = Setup;                ToolTip = 'Manage your deployed default reports.';                Visible = false;                ObsoleteReason = 'This functionality is no longer supported.';                ObsoleteState = Pending;                ObsoleteTag = '27.0';                trigger OnAction()                begin                    Page.RunModal(Page::"Power BI Deployments");                    // TODO: Set this button's visibility to equal "IsSaaS" so it's not visible for on-prem, where we won't have OOB uploads anyways.                end;            }#endif        }        area(Promoted)        {            group(Category_Category4)            {                Caption = 'Manage', Comment = 'Generated from the PromotedActionCategories property index 3.';                actionref(EnableReport_Promoted; EnableReport)                {                }                actionref(DisableReport_Promoted; DisableReport)                {                }#if not CLEAN27#pragma warning disable AL0432                actionref(CleanDeployments_Promoted; CleanDeployments)#pragma warning restore AL0432                {                    Visible = false;                    ObsoleteReason = 'This functionality is no longer supported.';                    ObsoleteState = Pending;                    ObsoleteTag = '27.0';                }#endif            }            group(Category_Category5)            {                Caption = 'Get Reports', Comment = 'Generated from the PromotedActionCategories property index 4.';                actionref(MyOrganization_Promoted; MyOrganization)                {                }                actionref(Services_Promoted; Services)                {                }            }        }    }    trigger OnOpenPage()    var        EnvironmentInfo: Codeunit "Environment Information";    begin        IsSaas := EnvironmentInfo.IsSaaSInfrastructure();        if not TryLoadReportsList() then            ShowLatestErrorMessage();    end;    trigger OnFindRecord(Which: Text): Boolean    var        OriginalFilterGroup: Integer;        OriginalFilter: Text;    begin        // If we are doing a cross-column search, always include the workspaces (e.g. for search in the page)        OriginalFilterGroup := Rec.FilterGroup();        Rec.FilterGroup(-1);        OriginalFilter := Rec.GetFilters();        if OriginalFilter <> '' then            Rec.SetRange(Type, Rec.Type::Workspace);        Rec.FilterGroup(OriginalFilterGroup);        exit(Rec.Find(Which));    end;    trigger OnNextRecord(Steps: Integer): Integer    begin        exit(Rec.Next(Steps));    end;    trigger OnAfterGetRecord()    begin        case Rec.Type of            Rec.Type::"Report":                IndentationValue := 1;            Rec.Type::Workspace:                IndentationValue := 0;        end;    end;    trigger OnQueryClosePage(CloseAction: Action): Boolean    begin        if (CloseAction in [Action::LookupOK, Action::OK]) or IsPageClosedOkay() then            SaveAndClose();    end;    var        PowerBIServiceMgt: Codeunit "Power BI Service Mgt.";        PowerBIWorkspaceMgt: Codeunit "Power BI Workspace Mgt.";        PageContext: Text[30];        IndentationValue: Integer;        IsPgClosedOkay: Boolean;        HasReports: Boolean;        IsSaas: Boolean;        IsErrorMessageVisible: Boolean;        ShowAdditionalFields: Boolean; // This value is always false, but dynamic visibility of fields enables testability        ErrorMessageText: Text;        FailedToLoadReportListTelemetryErr: Label 'PowerBIReportSelection failed to load reports. Error message: %1', Locked = true;    procedure SetContext(ParentContext: Text[30])    begin        // Sets the ID of the parent page that reports are being selected for.        PageContext := ParentContext;    end;    [TryFunction]    local procedure TryLoadReportsList()    begin        // Clears and retrieves a list of all reports in the user's Power BI account.        Rec.Reset();        Rec.DeleteAll();        PowerBIWorkspaceMgt.GetReportsAndWorkspaces(Rec, PageContext);        if Rec.IsEmpty then begin            HasReports := false;            Rec.Insert(); // Hack to prevent empty list error.        end else begin            HasReports := true;            // Set sort order, scrollbar position, and filters.            Rec.SetCurrentKey(WorkspaceID, Type, Name); // Ensures that workspaces show up as collapsible groups            Rec.FindFirst();        end;    end;    local procedure SaveAndClose()    var        PowerBIDisplayedElement: Record "Power BI Displayed Element";        PowerBIContextSettings: Record "Power BI Context Settings";        TempPowerBISelectionElement: Record "Power BI Selection Element" temporary;    begin        // Use a temp buffer record for saving to not disturb the position of the source table        TempPowerBISelectionElement.Copy(Rec, true);        PowerBIDisplayedElement.SetRange(UserSID, UserSecurityId());        PowerBIDisplayedElement.SetRange(Context, PageContext);        PowerBIDisplayedElement.DeleteAll(true);        PowerBIDisplayedElement.Reset();        TempPowerBISelectionElement.SetRange(Enabled, true);        if TempPowerBISelectionElement.Find('-') then            repeat                if TempPowerBISelectionElement.Type = TempPowerBISelectionElement.Type::"Report" then begin                    PowerBIDisplayedElement.Init();                    PowerBIDisplayedElement.ElementId := PowerBIDisplayedElement.MakeReportKey(TempPowerBISelectionElement.ID);                    PowerBIDisplayedElement.UserSID := UserSecurityId();                    PowerBIDisplayedElement.ElementType := TempPowerBISelectionElement.Type;                    PowerBIDisplayedElement.ElementName := TempPowerBISelectionElement.Name;                    PowerBIDisplayedElement.Context := PageContext;                    PowerBIDisplayedElement.ElementEmbedUrl := TempPowerBISelectionElement.EmbedUrl;                    PowerBIDisplayedElement.WorkspaceName := TempPowerBISelectionElement.WorkspaceName;                    PowerBIDisplayedElement.WorkspaceID := TempPowerBISelectionElement.WorkspaceID;                    PowerBIDisplayedElement.ShowPanesInNormalMode := false;                    PowerBIDisplayedElement.ShowPanesInExpandedMode := true;                    PowerBIDisplayedElement.Insert(true);                end            until TempPowerBISelectionElement.Next() = 0;        if not PowerBIDisplayedElement.Get(UserSecurityId(), PageContext, Rec.ID, Rec.Type) then begin            PowerBIDisplayedElement.SetRange(UserSID, UserSecurityId());            PowerBIDisplayedElement.SetRange(Context, PageContext);            if not PowerBIDisplayedElement.FindFirst() then                Clear(PowerBIDisplayedElement);        end;        PowerBIContextSettings.CreateOrUpdateSelectedElement(PowerBIDisplayedElement);        IsPgClosedOkay := true;        CurrPage.Close();    end;    procedure IsPageClosedOkay(): Boolean    begin        exit(IsPgClosedOkay);    end;    local procedure ShowLatestErrorMessage()    begin        ErrorMessageText := GetLastErrorText();        if ErrorMessageText = '' then            ErrorMessageText := PowerBIServiceMgt.GetGenericError();        IsErrorMessageVisible := true;        Session.LogMessage('0000F5B', StrSubstNo(FailedToLoadReportListTelemetryErr, GetLastErrorText(true)), Verbosity::Warning, DataClassification::OrganizationIdentifiableInformation, TelemetryScope::ExtensionPublisher, 'Category', PowerBIServiceMgt.GetPowerBiTelemetryCategory());    end;}