How to show Indicator results in Power BI

From Tygron Support wiki
Revision as of 16:15, 30 January 2024 by Frank@tygron.nl (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 which can 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 PowerBI.
  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 PowerBI, 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. When the data has loaded, select the HTML table, and load it.
  8. When the data has loaded, in the Data panel on the right, expand the data listing for the added Table, and ensure all data is checked.
  9. The data is now visible as a table in PowerBI.