Embed Power BI content in web client with new page type

Enabled for	Public preview	General availability
Users, automatically	-	Apr 1, 2025

Business value

Get an enhanced user interface when you view embedded Power BI reports in Business Central. The new interface makes it easier to navigate and interact with your data.

Feature details

This release wave introduces a new page type that enhances the Power BI report embedding experience. Power BI reports display in a slim, visually appealing, and user-friendly interface. Key improvements include:

• The interface removes irrelevant buttons, such as Delete and Edit, for embedded reports.
• The interface refines and balances margins and spacing around reports.
• The interface uses titles that take up less space.
• The interface adds new zoom and fit-to-page controls.

These enhancements apply to most Power BI reports in Business Central, so you get a consistent, improved experience across the platform. The following images show the difference between the previous and new experiences for the Sales Report:

Before

Now

New UserControlHost page type

The UserControlHost page type in AL enables the new Power BI report embedded experience. The UserControlHost page type simplifies embedding custom controls, such as Power BI reports, compared to using a Card page type in previous releases by removing unnecessary complexities.

Key aspects of the page type include:

• It excludes properties and triggers that don't apply to control add-ins, such as the SourceTable property and the OnAfterGetRecord trigger.
• In the UI, the embedded control takes up the entire page space, so there are no extra actions or buttons.
• Developers can easily use the page type in AL code.

Consider this simplified code example of a page that shows a WebPageViewer control by using the Card page type.

page 50100 UserControl
{
    PageType = Card;
    ApplicationArea = All;
    SourceTable = Customer;
    InsertAllowed = false;
    ModifyAllowed = false;
    DeleteAllowed = false;
    Editable = false;
    Caption = 'UserControl Example';

    layout
    {
        area(Content)
        {
            usercontrol(Webpageview; WebPageViewer)
            {
                ApplicationArea = All;

                trigger ControlAddInReady(callback: text)
                begin
                    CurrPage.Webpageview.Navigate(HyperLinkTxt)
                end;
                trigger Refresh(CallbackUrl: Text)
                begin
                    CurrPage.Webpageview.Navigate(HyperLinkTxt)
                end;
            }
        }
    }
}

The following code uses the UserControlHost page type. The UserControlHost page type doesn't allow the SourceTable, InsertAllowed, ModifyAllowed, and DeleteAllowed properties.

page 50122 UserControl
{
    PageType = UserControlHost;
    ApplicationArea = All;
    Editable = false;
    Caption = 'UserControl Example';

    layout
    {
        area(Content)
        {
            usercontrol(Webpageview; WebPageViewer)
            {
                ApplicationArea = All;

                trigger ControlAddInReady(callback: text)
                begin
                    CurrPage.Webpageview.Navigate(HyperLinkTxt)
                end;

                trigger Refresh(CallbackUrl: Text)
                begin
                    CurrPage.Webpageview.Navigate(HyperLinkTxt)
                end;
            }
        }
    }
}

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

Additional resources

The UserControlHost page type (docs)