Customize Power BI

Introduction

If customizations are made to the out of the box Power BI report, when BrightWork releases upgrades that include an updated Power BI report you will need to either keep your own customized report, or use the report included in the upgrade and then apply your own customizations. We recommend creating a separate Power BI report for customizations (with an optional custom link, e.g., in the app's Site Map) rather than editing the out of the box Power BI report. You can save a copy of the out of the box Power BI report and work in that copy. Contact your Customer Success Partner for additional information related to your specific implementation.

Note: Customization of Power BI reports requires a Microsoft Power BI Pro license or an E5/G5 plan (which includes Power BI), and installation of the Microsoft Power BI Desktop application.

To access BrightWork 365 Power BI reports, click into the Reports area on the Nav.


See our product installation article for initial Power BI set up instructions.

For additional Power BI information see these Microsoft resources:


Add a Column to a Custom Power BI Report

  1. In the Power BI Desktop application load your Power BI PBIX file, and ensure the latest data is refreshed. 
  2. Choose Transform Data in the ribbon to launch the Power Query Editor.
  3. Select the table name in the Queries section.
  4. In Applied Steps, click on Removed Other Columns and click its settings gear.
  5. Select the desired column and click OK.
  6. If necessary to rename the column, in Applied Steps click Renamed Columns, double-click on the column in the table header, rename it, and choose to insert a step when asked.
  7. Choose Close & Apply in the ribbon to close the Power Query Editor and return to Power BI Desktop.
  8. In Power BI Desktop, click into the area of the report page where you want to add the column.
  9. Click on the table name in the Fields section.
  10. Select the new column under the table name in the Fields section to add it to the Visualizations section.
  11. In the Visualizations section drag the column vertically to place it into the desired location.
  12. Save the report.
  13. Publish the report to the relevant Power BI destination.
  14. Launch Power BI Online (app.powerbi.com) and navigate to the relevant workspace.
  15. If necessary, configure the relevant Dataset's Schedule refresh settings.
  16. Click on your custom report to launch it.
  17. Choose File > Embed report > Website or portal.
  18. Copy the "embed" link and share with whomever you provided report access to.

Add a Custom Power BI Report Dashboard Link in the App

See important general customization information in our article Read First: Customization Recommendations.

In addition to opening custom Power BI reports in a browser tab, you can choose to add a new link to the Dashboards section of the app.

To add a new custom Power BI Report Dashboard link:

  1. Open your unmanaged solution in make.powerapps.com.
  2. Click + New > Dashboard > Power BI embedded.

  3. Enter a Display name.
  4. Choose Type Power BI report, select the relevant Power BI Workspace and your custom Power BI report.
  5. Click Save.
  6. Publish the customization.
  7. Return to the main customization screen of the unmanaged solution.
  8. Click Add existing > App > Model-driven app, and add the out of the box BrightWork 365 app.
  9. Click into the app that is of type Model-Driven App, and click Switch to classic.

  10. In the Artifacts section click on Dashboards.

  11. Scroll down the Classic Dashboards list to the Power BI Embedded Dashboards section and select your custom dashboard.
  12. Save and Publish.
  13. Back on the main (non-Classic) design screen scroll down to the Dashboards section, click the ellipses for your new custom Dashboard and choose Edit.

  14. Change the name of the dashboard to include a prefix number that will place it in the proper vertical order in the app's Dashboard drop-down list, e.g., "8. Acme Power BI" or "08. Acme Power BI".
  15. Save and Close the edit screen.
  16. Publish the customization.