nerdexam
Microsoft

DP-500 · Question #85

You need to use Power BI to ingest data from an API. The API requires that an API key be passed in the headers of the request. Which type of authentication should you use?

The correct answer is C. Web API. To ingest data from an API requiring an API key in the headers of the request, Power BI's Web API authentication type should be used.

Query and transform data

Question

You need to use Power BI to ingest data from an API. The API requires that an API key be passed in the headers of the request. Which type of authentication should you use?

Options

  • Aorganizational account
  • BBasic
  • CWeb API
  • DAnonymous

How the community answered

(21 responses)
  • A
    10% (2)
  • C
    86% (18)
  • D
    5% (1)

Why each option

To ingest data from an API requiring an API key in the headers of the request, Power BI's Web API authentication type should be used.

Aorganizational account

Organizational account authentication is for APIs secured by identity providers like Azure AD, requiring user sign-in with corporate credentials, which is different from an API key.

BBasic

Basic authentication sends a username and password in the request header, which is not the same as providing a single API key.

CWeb APICorrect

Power BI's Web API authentication method is specifically designed for scenarios where an API key needs to be passed for authentication. This method allows you to input the API key, which Power BI then includes in the request headers (or query parameters, depending on configuration) when connecting to the API.

DAnonymous

Anonymous authentication sends no credentials, which would fail for an API explicitly requiring an API key for access.

Concept tested: Power BI data connector authentication methods

Source: https://learn.microsoft.com/en-us/power-query/connectors/web/web-api-authentication

Topics

#Power BI#API integration#Data ingestion#Authentication

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice