Query using Microsoft Power BI Desktop

You can use Microsoft Power BI Desktop to access data from the Reporting API and create custom reports.

Connect to the Reporting API

Note: You must complete these steps the first time you use a Microsoft Power BI Desktop file to connect to the Reporting API.

1. Open a new file in Microsoft Power BI Desktop.
2. Click Get Data > OData feed.
3. In the OData feed dialog box, type the URL for your region in the URL field.

   Note: Add '/discover' at the end of the URL - https://<region>-reporting.promapp.io/odata/discover.

   Based on your region, use one of the following URLs to connect to the Reporting API.

   Region	Reporting API URL
   Australia	https://au-reporting.promapp.io/odata
   United States	https://us-reporting.promapp.io/odata
   Europe	https://eu-reporting.promapp.io/odata
   Canada	https://ca-reporting.promapp.io/odata
   UAE	https://ae-reporting.promapp.io/odata

4. Click OK.
5. Click Transform Data

6. The Power Query Editor window is displayed.

   Note: If you get a connection error, click File > Options and Settings > Options > Data Load > Clear Cache.
   

7. In the Power Query Editor window, under the Home tab, click Manage Parameters > New Parameter.
8. In the Name field, type API Key.
9. Type Promapp Reporting API Key in the Description field.
10. Ensure the Required check box is selected.
11. From the Type drop-down list, select Text.
12. In the Current Value field, enter the API token value you have copied as described in the topic: Create API token.
13. Click OK.
14. On the left pane, click Query.
15. In the Home tab, click Advanced Editor.
16. In the Advanced Editor window, copy and paste the following:

let

AccessTokenHeader = "Bearer " & #"API Key",

Headers = [Authorization=AccessTokenHeader],

Source = OData.Feed("<Reporting API URL>", Headers)

in

Source

17. Click Done.

    The list of tables for the supported endpoints is displayed. For more information about the endpoints, see API Reference.

18. To exit the Power Query editor and load data in the file, click Close & Apply.

You can save the file with the configured values and use the Power Query Editor to customize data and create reports.

Create a report

After you have connected to the Reporting API Odata feed, you can use the Microsoft Power BI file to create custom reports.

1. Open the file in Microsoft Power BI Desktop.

2. Click Edit Queries > Edit Queries.

3. In the Power Query Editor window, the list of tables for the supported endpoints is displayed. For more information about the endpoints, see API Reference.

Note: The Discover table is only a placeholder for OData feed validation and this link will not display any data.

4. In the Data column, click on the Table link to display data for the corresponding table. The table fields are displayed with the corresponding data in rows. For more information about the columns, see the Properties tables in API Reference.
• To select a different table:
  • Click View > Query Settings.
  • On the right pane, click Query Settings > Source to display the list of available tables.
• To refresh data, click Refresh Preview > Refresh All. The data is not refreshed in real-time and it can take up to 8 hours to fetch the updated details.

You can use the Power Query Editor to customize data and create reports. For more information, see the Microsoft Power BI documentation.

Query using Microsoft Power BI Desktop