Rest API connection with Proofpoint

[Ramendra]

Hi All,

I have proofpoint API documentation but I am not sure how to use it with Power BI.
Can some one please help me with this.

Below is api documentation

apiDoc: Proofpoint Security Awareness Training Results API - 0.1.0 (securityeducation.com)

[v-luwang-msft · Accepted solution]

Hi @Ramendra ，

Please review the content in the following links, hope they can help you resolve the problem.

1. Get data from web error: A web API key can only be specified when a web API key name is provided

   Solution: 

1. Open Power BI Desktop and on the Home tab, select Get data and choose the Web option.
2. Paste your metric query's URL into the Power BI dialog asking for the Web page URL.
3. In the Access web content dialog, select Basic, enter your app's API key as the Username, and press Connect

2. How to specify an API key name in Excel - A web API key can only be specified when a web API key nam...

  Solution: Add ApiKeyName = "ApiKey" as part of the 3 parameter of using OData.Feed

let
    Source = OData.Feed("https://localhost/odata", null, [Implementation="2.0", ApiKeyName = "ApiKey"]),
    Table_table = Source{[Name="Table",Signature="table"]}[Data]
in
    Table_table​

3. A web API key can only be specified when a web API key name is provided

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Ramendra]

They Provide access token but Power BI do not accept it.
it says 

[lbendlin]

Read about the ApiKeyName section here : Web.Contents - PowerQuery M | Microsoft Docs

[lbendlin]

Looks straightforward. However, without actual access to the API it will be close to impossible to assist you. Doesn't look like they offer sandbox logins.