Rest API connection with Proofpoint

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