How to show Indicator results in Power BI

From Tygron Support wiki
Jump to navigation Jump to search

When a Project's calculations lead to large datasets as results, it can be desirable to use additional tooling to inspect and further process the output. One such application that can be used for processing and dashboarding is Microsoft Power BI.

Editor → Current Situation (Ribbon tab) → Indicators (Ribbon bar) → The Indicator to edit (Left panel)
How to show Indicator results in Power BI:
  1. Go to Current SituationIndicators.
  2. In the left panel, select the Indicator to add to Power BI.
  3. In the right panel, click on "Open In Web Browser". The web browser will open with the Indicator's output.
  4. Copy the URL in the address bar of the web browser.
  5. In Power BI, click on "Get Data", and opt to obtain data from a Web source.
  6. For URL, use the URL of the Indicator's web page obtained previously.
  7. Once the data has loaded, select and load the HTML table.
  8. In the Data panel on the right, expand the listing for the added table and ensure all data is checked.
  9. The data is now visible as a table in Power BI.