OD41

23 Oktober 2025

Data Loading & Visualization in Power BI: Loading Data from Cloud Storage

 

Question:

You would like to load data into Power BI from an Amazon S3 bucket, but you see there is no direct connector to do so. How can you achieve this without a connector?

  • By writing a Python script to load data into S3

Question
:

Identify the statement that describes BigQuery most effectively?

  • BigQuery is a serverless, auto-scaled, SQL-like data warehouse available on GCP


Question

:

You would like to load data from GCP BigQuery into Power BI. What is the recommended way to authenticate yourself from Power BI?

  • By using a GCP service account with only the permissions Power BI needs


Question

:

You would like to load data from Azure Blob Storage into Power BI. What is the recommended way for you authenticate yourself from Power BI?

  • By using the connection string for the storage account which allows access


Question

:

This data visualizes revenue and profit of a superstore over time. Based on this, what is the broad trend for the revenue and profit over time?

  • Revenue up, profit up less sharply


Question

:

You have a REST API with data displayed in a tabular format, and you would like to read this data into Power BI. Which connector can you use for this?

  • The Web connector


Question

:

From which of these sources can the Power BI Web connector read data?

  • An HTML page

  • A REST API


Question

:

This chart visualizes the total yield of honey on the X-axis, and the average yield per colony on the Y-axis for different US states. Based on this, which state has the highest total yield?



  • ND


Question

:

You have data for sales of a product in countries, states, and cities. You would like to view this data in a tabular format, while retaining the ability to drill-down into hierarchies. Which Power BI widget can you use for this?

  • Matrix


Question

:

You would like to load data from AWS S3 into Power BI. What is the recommended way for you authenticate yourself from Power BI?

  • By passing in an access key ID and secret access key for a user with the necessary permissions