Page 6320 Upload Power BI Report
src/Layers/W1/BaseApp/Modules/System/PowerBI/APIs/UploadPowerBIReport.Page.al153 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Integration.PowerBI;using System.IO;using System.Utilities;/// <summary>/// Allows users to upload report files to Business Central, which will automatically deploy them to Power BI./// </summary>page 6320 "Upload Power BI Report"{ Caption = 'Upload Power BI Report'; PageType = NavigatePage; SourceTable = "Power BI Customer Reports"; layout { area(content) { field(FileName; FileName) { ApplicationArea = All; AssistEdit = true; Caption = 'File'; Editable = false; ShowMandatory = true; ToolTip = 'Specifies File Name'; trigger OnAssistEdit() var TempFileName: Text; begin // Event handler for the ellipsis button that opens the file selection dialog. TempFileName := FileManagement.BLOBImportWithFilter(TempBlob, FileDialogTxt, '', FileFilterTxt, ExtFilterTxt); if TempFileName = '' then // User clicked Cancel in the file selection dialog. exit; FileName := TempFileName; if ReportName = '' then begin ReportName := CopyStr(FileManagement.GetFileNameWithoutExtension(FileName), 1, 200); IsFileLoaded := true; end; end; } field(ReportName; ReportName) { ApplicationArea = All; Caption = 'Report Name'; Editable = IsFileLoaded; ShowMandatory = true; ToolTip = 'Specifies Report Name'; } } } actions { area(creation) { action("Upload Report") { ApplicationArea = Basic, Suite; Caption = 'Upload Report'; Image = Import; InFooterBar = true; Visible = true; trigger OnAction() var PowerBICustomerReports: Record "Power BI Customer Reports"; RecordRef: RecordRef; begin if FileName = '' then Error(FileNameErr); if ReportName = '' then Error(ReportNameErr); PowerBICustomerReports.SetFilter(Name, ReportName); if not PowerBICustomerReports.IsEmpty() then Error(BlobNameErr); PowerBICustomerReports.Reset(); if PowerBICustomerReports.Count() >= MaxReportLimit then Error(TableLimitMsg); PowerBICustomerReports.Init(); PowerBICustomerReports.Id := CreateGuid(); PowerBICustomerReports.Name := ReportName; RecordRef.GetTable(PowerBICustomerReports); TempBlob.ToRecordRef(RecordRef, PowerBICustomerReports.FieldNo("Blob File")); RecordRef.SetTable(PowerBICustomerReports); PowerBICustomerReports.Version := 1; PowerBICustomerReports.Insert(); Commit(); FileName := ''; ReportName := ''; IsFileLoaded := false; CurrPage.Update(false); Message(UploadMsg); end; } } } trigger OnInit() begin MaxReportLimit := 20; end; trigger OnOpenPage() begin if not PowerBIServiceMgt.IsUserAdminForPowerBI(UserSecurityId()) then Error(PermissionErr); if not PowerBIServiceMgt.IsUserReadyForPowerBI() then Error(NotReadyErr); end; trigger OnClosePage() begin if PowerBIReportSynchronizer.UserNeedsToSynchronize('') then PowerBIServiceMgt.SynchronizeReportsInBackground(''); end; var TempBlob: Codeunit "Temp Blob"; PowerBIServiceMgt: Codeunit "Power BI Service Mgt."; PowerBIReportSynchronizer: Codeunit "Power BI Report Synchronizer"; FileManagement: Codeunit "File Management"; ReportNameErr: Label 'You must enter a report name.'; FileNameErr: Label 'You must enter a file name.'; NotReadyErr: Label 'The Power BI Service is currently unavailable.'; TableLimitMsg: Label 'The Customer Report table is full. Remove a report and try again.'; BlobNameErr: Label 'A blob with this name already exists.'; UploadMsg: Label 'The report has been added for deployment. Once deployed, it will appear in the select reports list.'; PermissionErr: Label 'User does not have permissions to operate this page.'; FileDialogTxt: Label 'Select a PBIX report file.'; FileFilterTxt: Label 'Power BI Files(*.pbix)|*.pbix'; ExtFilterTxt: Label 'pbix', Locked = true; FileName: Text; ReportName: Text[200]; IsFileLoaded: Boolean; MaxReportLimit: Integer;}