Exam PL-300 topic 1 question 54 discussion

Actual exam question from Microsoft's PL-300

Question #: 54
Topic #: 1

HOTSPOT
-

You plan to use Power Query Editor to get data from an API.

The API returns a JSON response.

You have a username and password for the API.

Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by 13a8051 at June 13, 2025, 9:16 p.m.

Comments

Submit Cancel

Lulu_2022

1 month, 1 week ago

- Data Source: → Web Power Query’s Web connector can handle REST APIs and retrieve JSON payloads via GET or POST requests. - Authentication Method: → Basic This allows you to securely provide your username and password for the API.

upvoted 2 times

...

13a8051

2 months ago

Data source: Web Power Query uses the Web connector to fetch data from APIs (which typically return JSON or XML). Authentication method: Basic Since you have a username and password, the most common authentication for APIs that require these is Basic Authentication (username and password sent encoded in the HTTP header). If the API uses some other auth method (like OAuth), that would differ, but given username/password, Basic Auth is the standard.

upvoted 3 times

...