Web data import in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Web Data Import Authentication

You want to import data from a web API that requires authentication. Which method should you use in Power BI to securely connect and import the data?

A Use the Web connector with anonymous access and include credentials in the URL query string.

B Use the Web connector and select the appropriate authentication method like Basic or OAuth in the credentials prompt.

C Use the Web connector with no authentication and hope the API allows public access.

D Download the data manually and import it as a CSV file instead of using the Web connector.

💡 Hint

Think about how Power BI handles secure connections and credentials for web sources.

Power BI's Web connector supports various authentication methods. Selecting the correct authentication type ensures secure and successful data import.

❓ dax_lod_result

intermediate

DAX Measure for Counting Web Import Refreshes

You have a table 'WebRefreshLog' with a column 'RefreshDateTime' recording each time the web data import refreshes. Write a DAX measure to count how many refreshes happened in the last 7 days.

Power BI

RefreshCountLast7Days = CALCULATE(COUNTROWS(WebRefreshLog), FILTER(WebRefreshLog, WebRefreshLog[RefreshDateTime] >= TODAY() - 7))

A RefreshCountLast7Days = CALCULATE(COUNTROWS(WebRefreshLog), FILTER(WebRefreshLog, WebRefreshLog[RefreshDateTime] >= TODAY() - 7))

B RefreshCountLast7Days = CALCULATE(COUNTROWS(WebRefreshLog), WebRefreshLog[RefreshDateTime] >= TODAY() - 7)

C RefreshCountLast7Days = COUNTROWS(FILTER(WebRefreshLog, WebRefreshLog[RefreshDateTime] >= TODAY() - 7))

D RefreshCountLast7Days = COUNTROWS(WebRefreshLog) - 7

💡 Hint

Remember that CALCULATE changes filter context and FILTER creates a table to filter on.

Option A correctly uses CALCULATE with FILTER to count rows where the refresh date is within the last 7 days.

❓ visualization

advanced

Best Visualization for Web Data Import Status Over Time

You want to create a dashboard visual showing the success or failure of web data imports over the past month, updated daily. Which visualization type best shows trends and status clearly?

A A line chart with two lines: one for success count and one for failure count per day.

B A table listing each refresh date and its status.

C A pie chart showing total success vs failure counts for the month.

D A clustered bar chart showing counts of success and failure by day.

💡 Hint

Think about how to best show trends over time with multiple categories.

A line chart with separate lines for success and failure counts per day clearly shows trends and comparisons over time.

🔧 Formula Fix

advanced

Debugging Web Data Import Query Failure

Your Power BI web data import query fails with an error: "Access denied". You confirmed the URL and credentials are correct. What is the most likely cause?

A The Power BI desktop version is outdated and cannot connect to web sources.

B The URL is missing the https:// prefix.

C The web API requires a user-agent header that Power BI is not sending by default.

D The data source is too large to import via web connector.

💡 Hint

Think about common web API security requirements beyond credentials.

Many web APIs require specific headers like user-agent for access. Without them, the server may deny access even if credentials are correct.

❓ data_modeling

expert

Modeling Web Data Import Logs for Performance Analysis

You have imported web data logs with columns: 'ImportID', 'StartTime', 'EndTime', 'Status'. You want to analyze average import duration by status and filter by date ranges efficiently. Which data model design is best?

A Create a calculated column 'Duration' as EndTime - StartTime; use EndTime as the only date filter column without a Date table.

B Create a measure to calculate duration on the fly as EndTime - StartTime; no Date table needed because filtering is done on StartTime column directly.

C Store duration externally and import it as a column; use StartTime as text for filtering to improve performance.

D Create a calculated column 'Duration' as EndTime - StartTime and use it in measures; add a separate Date table linked to StartTime for filtering.

💡 Hint

Think about best practices for time calculations and filtering in Power BI models.

Calculated columns for duration allow easy aggregation. A separate Date table linked to StartTime enables efficient and flexible date filtering.

Practice

1. What is the main purpose of using Web data import in Power BI?

easy

A. To create visualizations from local Excel files

B. To bring online data into Power BI for analysis

C. To write DAX formulas for calculations

D. To design dashboards without data

Solution

1. Step 1: Understand the role of Web data import

   Web data import allows Power BI to connect to online sources and bring data into the report.

2. Step 2: Compare options with this purpose

   Options B, C, and D describe other Power BI features unrelated to web data import.

3. Final Answer:

   To bring online data into Power BI for analysis -> Option B

4. Quick Check:

   Web data import = bring online data [OK]

Hint: Web import means getting data from internet sources [OK]

Common Mistakes:

• Confusing web import with local file import
• Thinking web import creates visuals directly
• Mixing web import with DAX formula writing

2. Which of the following is the correct first step to import data from a website in Power BI?

easy

A. Create a new measure in the report view

B. Open Power Query and write a DAX formula

C. Click 'Get Data' then select 'Web' and enter the URL

D. Export data from Power BI to Excel

Solution

1. Step 1: Identify the import process

   To import web data, you start by clicking 'Get Data' and choosing 'Web' as the source.

2. Step 2: Check other options

   Options A, B, and D do not describe the correct import steps for web data.

3. Final Answer:

   Click 'Get Data' then select 'Web' and enter the URL -> Option C

4. Quick Check:

   First step for web import = Get Data > Web [OK]

Hint: Start with Get Data > Web for web imports [OK]

Common Mistakes:

• Trying to write DAX before importing data
• Confusing report view with data import steps
• Exporting data instead of importing

3. After importing data from a website URL in Power BI, which step is usually needed to prepare the data for reports?

medium

A. Transform and clean the data in Power Query Editor

B. Directly create visuals without any changes

C. Write complex DAX measures before loading data

D. Export the data back to the website

Solution

1. Step 1: Understand data preparation after import

   Imported web data often needs cleaning and transforming to be useful.

2. Step 2: Evaluate options

   Transform and clean the data in Power Query Editor correctly states using Power Query Editor to transform data. Options A, C, and D are incorrect or irrelevant.

3. Final Answer:

   Transform and clean the data in Power Query Editor -> Option A

4. Quick Check:

   Data prep after import = transform in Power Query [OK]

Hint: Always clean web data in Power Query before reporting [OK]

Common Mistakes:

• Skipping data cleaning and using raw data
• Trying to write DAX before loading data
• Exporting data instead of preparing it

4. You tried to import data from a website but got an error saying the URL is invalid. What is the most likely cause?

medium

A. The URL is missing the 'http://' or 'https://' prefix

B. Power BI does not support web data import

C. You forgot to write a DAX formula first

D. The data is already loaded in Power BI

Solution

1. Step 1: Identify common URL errors

   Web URLs must include 'http://' or 'https://' to be valid for import.

2. Step 2: Check other options

   Power BI supports web import (B wrong), DAX is unrelated (C wrong), and data loaded already doesn't cause URL errors (D wrong).

3. Final Answer:

   The URL is missing the 'http://' or 'https://' prefix -> Option A

4. Quick Check:

   URL must start with http:// or https:// [OK]

Hint: Check URL starts with http:// or https:// [OK]

Common Mistakes:

• Ignoring URL format requirements
• Thinking DAX is needed before import
• Assuming Power BI can't import web data

5. You want to create a Power BI report that updates daily with sales data from a web API. Which approach is best to ensure fresh data?

hard

A. Export Power BI data to the web API

B. Manually copy and paste data from the website daily

C. Write DAX measures to fetch data from the web

D. Use Web data import with scheduled refresh enabled

Solution

1. Step 1: Understand data refresh options

   Using Web data import with scheduled refresh allows automatic daily updates from the web API.

2. Step 2: Evaluate other options

   Manual copy-paste (B) is inefficient, DAX cannot fetch web data (C), and exporting data (A) is opposite of importing.

3. Final Answer:

   Use Web data import with scheduled refresh enabled -> Option D

4. Quick Check:

   Scheduled refresh + web import = fresh daily data [OK]

Hint: Enable scheduled refresh for automatic web data updates [OK]

Common Mistakes:

• Relying on manual data updates
• Trying to fetch web data with DAX
• Confusing export with import