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 Excel. This does not provide details on specific steps on how to use the data and instead focuses on how to connect only.

1. Activate the Data Tab
2. Connect Using Excel

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. Activate the Data Tab

To connect to PleaseReport via Excel you will need to activate the data tab. To do this:

1. Launch Excel.
2. Click File, then Options.
3. Click on the Data tab.
4. Activate the data options you require.

2. Connect Using Excel

To connect to PleaseReport:

1. Launch Excel.
2. Open the Data tab.
3. Click on Get Data, then From Other Sources, and finally Blank Query.
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. Click [Done]. The system now displays a list of views that are available for reporting.

Need help with Excel? Please visit the Microsoft Excel data support page.