REST Reporting API - Power BI Example "/reporting/Dps"

Requirements

  • Read the chapter Requirements and Installation.

  • Install a reporting tool that supports JSON via URL, e.g. Power BI, BIRT or Excel.

  • Start your project and generate some test-data using the example panel:

    Panel\Examples\ReportingSampleData.pnl

  1. Check if the REST Reporting API returns data as desired by entering URL into the Web Browser of your choice (e.g.):

    https://localhost:2444/reporting/Dps?from=2023-02-13T12:00:00.000Z&to=2023-02-13T15:00:00.000Z&&System1:ExampleDP_Rpt1.&System1:ExampleDP_Rpt2

    Figure 1. REST Reporting API - URL in Browser
    REST Reporting API - URL in Browser
  2. Open the Power BI. Consider the Requirements and Installation e.g. regarding certificates.
    Note:
    Note also that historical data must be available.

  3. In order to use Reporting, add the URL https://localhost:2444/reporting/Dps?from=2023-02-13T12:00:00.000Z&to=2023-02-13T15:00:00.000Z&&System1:ExampleDP_Rpt1.&System1:ExampleDP_Rpt2 via Get data > Web.

    Figure 2. Rest Reporting API - get Data
    Rest Reporting API - get Data
  4. Configure the URL and click OK.
    Figure 3. Enter URL
    Enter URL
  5. The Query Editor is opened. Enter a proper name for the query. The query is for the datapoints Rpt1 and Rpt2:
    Figure 4. Query in the Query Editor
    Query in the Query Editor
  6. Change the type of the dps.results.data.value to Decimal:
    Figure 5. Change Type
    Change Type
  7. Close the window and apply the changes:
    Figure 6. Close the Window and apply Changes
    Close the Window and apply Changes
  8. Save the file Example.pbix
    Figure 7. Save the Example
    Save the Example
  9. The Main window is opened. In the Visualizations area add a line chart:
    Figure 8. Add a Line Chart
    Add a Line Chart
  10. Drag the dps.result.data.timestamp to the Axis field and change from date hierarchy to dps.result.data.timestamp: by applying the change.
    Figure 9. Add a Line Chart
    Add a Line Chart
  11. Drag dps.DP to the Legend and dps.result.data.value to Values.
  12. The result should look as follows:
    Figure 10. Result
    Result
  13. Add a table:
    Figure 11. Add a Table
    Add a Table
  14. Drag dps.result.data.manager to Values.
    Figure 12. dps.result.data.manager to Values
    dps.result.data.manager to Values
  15. Drag dps.result.data.timestamp to Values.
    Figure 13. dps.result.data.timestamp to Values.
    dps.result.data.timestamp to Values.
  16. Drag dps.DP to Values.
    Figure 14. dps.DP to Values
    dps.DP to Values
  17. The result should look as follows:
    Figure 15. Result
    Result