PowerBi Extra is a tool or feature designed to enhance the data visualization capabilities in the Microsoft Dynamics 365 Business Central software environment. Its primary function is to enable users to access and display a comprehensive set of data visualizations, often comprising various charts, graphs, and reports, all from within the Business Central platform.

This enhancement is particularly valuable because it simplifies accessing and analyzing data. Instead of switching between different applications or tools to view multiple visualizations, users can remain within the familiar Business Central interface. By providing a full display of these visualizations, PowerBi Extra offers a more holistic and efficient way for users to gain insights from their data.

In practical terms, this means that users can quickly access and interact with diverse data representations, aiding in decision-making, trend analysis, and data-driven actions directly within the Business Central environment. This streamlines workflows saves time, and enhances the user experience for those working with complex data sets or business intelligence needs.

PowerBI Extra is currently available on Cloud, Software As A Service (SAAS) only.

Availability of PowerBi Extra Functionality

PowerBi Extra can be found on many pages (as listed in the below screenshots). It can be seen on List Pages and even Card Pages. The availability of this add-on is seen within the Factbox Pane, Details section.

It is important that the user acquires the PowerBi Licence to have this functionality available for use, otherwise, the above section will not appear within the fact box area.

By analysing and retrieving data from Business Central pages, the add-on transforms it into an easy-to-understand graph. Whether the add-on is available on sales orders, bank accounts, assets and item pages users can spot trends, patterns, and anomalies that might go unnoticed when viewing the entire page. Therefore it gives the user a quick overview of the page in a very concise manner.

Adding a PowerBi Report

Users can add a new report by clicking on the ‘Select reports’ hyperlink. This in turn directs the user to a modal to choose the desired PowerBi Report.

From here the user chooses the report and the add-on immediately sets up the graph or other graphical data to the corresponding page.

In this case according to the Bank Account the user is on the appropriate information is shown.

If then the user enters the Bank Account Card, different data is visible.

Copying Image

When hovering over the PowerBi add-on the user can copy the image with the caption included by clicking on the below icon:

Filtering Data

The user can also filter the visible data by clicking on the below icon:

Focus Mode

The user also has the ability to focus on the entire graph by clicking on the below icon

To go back to the original data representation the ‘Back to report’ button must be clicked.

Choosing another Report

If for some reason the user previously chose an incorrect report to display on screen, it can be changed by clicking on the PowerBi heading, which will show multiple options. Then the first option 'Select Report’ must be chosen and the same process as mentioned before must be followed.

Expanding the Report

If the user wishes to further expand and and view the graph of relevant information at a bigger scale, the user must once more click on the PowerBi heading and choose ‘Expand Report’ option.

The user can wish to scroll left and right to view other parts of the data shown. Filtering is also possible in this view.

Choosing the Previous Report

In the case of having multiple reports for the same list or card page, the user can skip to the previous report by clicking on the ‘Previous Report’ button. Once clicking on this button the add-on will automatically display the previous report on screen.

Choosing the Next Report

Similar to choosing the previous report, the user can also choose next report in queue by clicking on the ‘Next Report’ option within the drop-down menu. Once again the next report will automatically show.

Managing a Report

If the user needs to edit something within the report visualization itself it can be done by choosing the ‘Manage Report’ option from the drop-down.

Edit Mode:

Once this option is chosen, the user will be directed to a more detailed aspect and view of the report itself. The user will be set inside the ‘Edit Mode’ panel at first as seen below.

Editing Mode Ribbon

File Drop-down Menu:

From here the user has the ability of either saving the report or saving a copy of the report by clicking the File drop-down button from the editing ribbon, and choosing one of the two options:

Save (which saves the modifications that were done to the report layout and applies the changes immediately)
Save as (which saves a copy of the report changes that have been done).

Once the Save button is chosen the user no longer has the ability to edit the Power BI report for a few seconds because the editing area is disabled. Then the user can edit as much as they desire, because the editing area is enabled for editing again.

If the Save as button is chosen the user will be prompted with a small modal in the middle of the screen, requesting a name for the new report copy.

If the user is satisfied with the changes applied, they must choose to save the report after giving a name within the available text area by clicking the Save button.

If there were some mistakes, the user can also choose to cancel the saving process by clicking the Cancel button.

View Drop-down Menu:

From the same editing ribbon the user has the View drop-down menu.

Fit to page:

The Fit to page option displays the report as is in the Editing Panel.

Fit to width:

The Fit to width option stretches the report layout to the full width of the editing area.

Then to view parts of the report the scroll bars on the side and at the bottom must be used.

Actual size:

The Actual size button resizes the report to the normal and actual size that it was originally.

High-contrast colours:

The High-contrast colours option has multiple views from which the user can choose from as listed below. Each type of high-contrast colour option has a particular theme, which is distinct from one another.

Selection pane:

Once enabling the Selection pane option, the selection pane will show on the right side of the editing panel.

The user can choose to either hide the Selection pane by clicking the switch option agian from the View drop-down menu, or use the 'x' button to close it.

The user can also choose to collapse the pane and still be visible on the side by clicking the arrow keys next to the close button.

Sync slicers pane:

By enabling the Sync slicers pane button the respective pane will show on the right side of the editing panel. Once again, if the user wishes to remove the pane they can either switch off the option or click on the 'x' button within the pane, and if the pane needs to be collapsed the arrow buttons must be used.

Insights pane:

When the user click the Insight pane option button the pane will show again on the right side of the editing area. Once again, if the user wishes to remove the pane they can either switch off the option or click on the 'x' button within the pane, and if the pane needs to be collapsed the arrow buttons must be used.

Text box Option:

This option will automatically put a text box on the report that is available on screen.

Here the user has the ability to enter any text, symbols, etc… that they desire. The text can also be edited using the standard editing tools. The text area can also be resized to the users preference. The text box can also be removed by clicking on the text area and pressing the delete key on the keyboard.

Shapes Option:

Once clicking on the below drop-down option the user has the ability to add different shapes which they desire to the report itself. The respective shape can also be removed by pressing the delete key on the keyboard.

Buttons Option:

This option within the ribbon enables the user to add certain buttons to the report layout. The icons that are seen on screen are the same as the icons next to their respective name. If the user wishes to remove the icon, the delete button on the keyboard must be pressed.

Refresh Option:

As the name of the button implies, when clicking on the Refresh option the editing area refreshes.

Duplicate this page Option:

The below option creates a duplicate of the existing Power BI report and this is visible at the bottom of the editing panel.

The duplicate report can be removed if not needed by hovering on the tab and clicking the ‘Delete page’ button as seen below.

Once clicking the 'x' button the user will be prompted with a modal in the middle of the editing area. The background will be disabled for the user and to remove the duplicate report visualization the Delete button should be clicked.

If the user does not want to delete it, the Cancel button must be clicked.

Save Option:

The user can also save the current edited report by clicking the Save button. Once clicking this button the editing area will be disabled and enabled again after a few seconds.

Filters Pane:

The filters pane lets the user to apply filters on the available report visualization. This pane can be collapsed using the arrow buttons.

If the user wishes to keep the filters but hide them for the moment, they should click on the eye icon within the pane itself.

Visualizations Pane:

From the below pane the user can add multiple graphical representations to the report itself by simply clicking on the one needed.

Data Pane:

This pane shows all the variables and possible data that can be added to the Power BI report.

Desktop layout view:

When opening the Management area the view is in Desktop layout view always.

Mobile layout view:

If the user wants to view the report layout in a different view, they can choose the Mobile layout view, by clicking the second icon.

After entering this layout view, the user can move the report layout from the Page visuals pane onto the mobile diagram.

The report layout can then be resized accordingly on the mobile diagram.

If the user wants to edit the report on the mobile layout view, they must do use using the Visualizations pane.

Moreover, the edited report can be saved from the File drop-down menu within the ribbon as explained previously.

View Mode:

The user also has the option to view the report in an enlarged mode and also apply filters to by choosing the View Mode button.

Refreshing the Page:

The available Power BI graphical report can be refreshed using the Refresh Page button.

Uploading a New Report

the user can choose a new report layout to upload from the PBIX file by clicking on the Upload Report option from the below drop-down.

Once clicking on this option, a modal will pop up and the user will be able to choose the needed report by clicking on the three dots as show below.

Then the user must drag and drop or select a PBIX report file from his device.

After choosing the report, Upload Report should be chosen to proceed.

Resetting All Reports

The last option within the drop-down menu is the Reset All Reports functionality. This button resets all Power BI setup in Business Central, for all users. Reports with the users Power BI workspace are not affected but need to be removed manually.

Pages where Power BI Extra is available:

Below are the pages where the PowerBi Extra add-on is available when enabled: