Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Hot Area / Sentence Completion
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Hotspot Solution:
Data source: Web Authentication: Basic To connect to an API returning JSON with username and password, here’s what you should select in Power Query Editor: Data Source: Web (Because APIs are accessed via URLs over HTTP/HTTPS.) Authentication Method: Basic or Web API (depending on the API’s authentication type) Typically: Use Basic Authentication if the API expects a username and password sent in the HTTP headers (standard). Use Web API key if the API requires a token/key instead of username/password. Since you have a username and password, Basic Authentication is the right choice.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Data Source: JSON Authentication: Basic JSON is a more specific connector, it works both for local and web resources.
Data source: Web Authentication: Basic To connect to an API returning JSON with username and password, here’s what you should select in Power Query Editor: Data Source: Web (Because APIs are accessed via URLs over HTTP/HTTPS.) Authentication Method: Basic or Web API (depending on the API’s authentication type) Typically: Use Basic Authentication if the API expects a username and password sent in the HTTP headers (standard). Use Web API key if the API requires a token/key instead of username/password. Since you have a username and password, Basic Authentication is the right choice.
- 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.