How to show Indicator results in Power BI
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:
- Go to Current Situation → Indicators.
- In the left panel, select the Indicator to add to Power BI.
- In the right panel, click on "Open In Web Browser". The web browser will open with the Indicator's output.
- Copy the URL in the address bar of the web browser.
- In Power BI, click on "Get Data", and opt to obtain data from a Web source.
- For URL, use the URL of the Indicator's web page obtained previously.
- Once the data has loaded, select and load the HTML table.
- In the Data panel on the right, expand the listing for the added table and ensure all data is checked.
- The data is now visible as a table in Power BI.
How-to's
- How to access your project in Power BI
- How to show Overlays in Power BI
- How to show polygon data in Power BI