Who is this article for?

Please Review administrators or data scientists.

Access keys for PleaseReport are required.

PleaseReport has been designed to surface the data on reviews and related information manner to aid reporting and analysis.

This article outlines the steps required to connect to PleaseReport using Microsoft Power BI. This does not provide details on specific steps on how to perform the data analysis as these steps vary depending on the tools you use.

1. Install Microsoft Power BI
2. Connect Using Power BI

Before you proceed, please ensure you have your PleaseReport Endpoint URL and the Access Keys. For details on how to request these please visit How to Request PleaseReport Access.

1. Install Microsoft Power BI

If you don't already have Power BI installed, then it can be downloaded for free from the Microsoft Store:

1. Browse to the Power BI Desktop page of the Microsoft Store.
2. Click Install.

More Assistance: For more assistance in installing Microsoft Power BI please visit the Microsoft Power BI website.

2. Connect Using Power BI

With Power BI installed and your keys on hand you are ready to connect to PleaseReport.

To connect:

1. Open Microsoft Power BI.
2. Click Get Data.
3. Select Blank Query and then click [Connect].

4. Click Advanced Editor (located in the Query section of the Home ribbon).
5. Enter the below power query code:

let
 Source =OData.Feed("https://tenant.ideagendata.com/odata/", null,
 [
 Headers = [#"X-IdeagenDataAPIKey"= "ACCESSKEY" ]
 ])
in
    Source

6. Update the code with your tenant and access key.
7. Power BI will display a warning that the credentials are invalid. Choose to Edit the credentials and select “Anonymous” from the list on the left. Press “Connect” to complete the connection.
8. Once connected, a list of views that can be included in reports is displayed. To use one of the views in a query, right mouse click on "Table" alongside the view you wish to include and, in the pop-up menu that appears, choose "Add as New Query".