Forum Discussion
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 Training Results API - 0.1.0 (securityeducation.com)
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:
- Open Power BI Desktop and on the Home tab, select Get data and choose the Web option.
- Paste your metric query's URL into the Power BI dialog asking for the Web page URL.
- In the Access web content dialog, select Basic, enter your app's API key as the Username, and press Connect
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_table3. 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 RegardsLucien
4 Replies
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.
They Provide access token but Power BI do not accept it.
it saysRead about the ApiKeyName section here : Web.Contents - PowerQuery M | Microsoft Docs
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:
- Open Power BI Desktop and on the Home tab, select Get data and choose the Web option.
- Paste your metric query's URL into the Power BI dialog asking for the Web page URL.
- In the Access web content dialog, select Basic, enter your app's API key as the Username, and press Connect
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_table3. 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 RegardsLucien
