Power BI

Note

We are currently doing a soft launch with a limited set of customers. The general release will be available in early February 2025 as a paid module. Please get in touch with your account manager in case you are interested.

Introduction

The Power BI embedded functionality allows you to build customized Power BI report based on SC Navigator results, without setting up the necessary infrastructure as that is all done in the background. The model currently only support a single report, and Power BI does not look or manage multiple users efficiently. Therefore, if multiple people in your organization are working on a report, it is important not to work simultaneously as changed might get lost.

(Results) Dataset

Datasets can be made available in two ways in Power BI.

The first way is via the “Save Results” dialog and by checking “Export to Data Lake/Power BI”, like this:

After you click save, the data will be saved and available in Power BI with the name you provided.

The second way is done automatically after the results of a solve are loaded. Upon loading of the results, that data is also uploaded to Power BI and available as “_current_<yourname>_N”, where N is an integer between 1 and 10. Normally, only the last one will be visible, but in some cases it might take some time to remove the previous data set, so you might see two.

Power BI Menu

The Power BI menu contains the most important button of this page. The “Save” button, all the way to the right or in the “File” menu on the left.

The reason this is the most important button is that Power BI does NOT auto save, so leaving this page without clicking the save button means that all the unsaved changes are lost. We recommend regularly clicking the save button to make sure that no changes is lost. (The “Save As” button in the file menu does not do anything.)

Edit/View Mode

Power BI embedded has two modes, edit and view. In “edit”, you can customize the report by adding new objects, new pages, and filters. In “view”, you can only view the created results and use the selected filters. By default, everybody can both “edit” and “view”. The default mode is “edit”, but that can be changed via a drop down menu on the “Edit/View Mode” side panel:

In case, you want to restrict certain users from being able to “edit” the report, you need to create a group on the platform called “Power BI View Only”. After you have created this group, you need to add the users to this group that should not be able to edit.