Forum Discussion

Ramendra's avatar
Ramendra
Helper IV
4 years ago
Solved

Rest API connection with Proofpoint

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 ...
Need Help
v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

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