Why connecting to data sources is the first step in Power BI - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Why is connecting to data sources the first step in Power BI?

Imagine you want to make a report about sales. Why must you connect to the data source first?

A Because Power BI only works with Excel files and no other data.

B Because connecting to data sources automatically creates all needed reports.

C Because connecting to data sources changes the data permanently.

D Because without data, Power BI cannot create any visuals or calculations.

💡 Hint

Think about what Power BI needs to show charts and numbers.

Power BI needs data to work with. Connecting to data sources brings the data into Power BI so you can build visuals and do analysis.

🎯 Scenario

intermediate

Choosing the right data source connection

You want to analyze customer feedback stored in a cloud database and sales data in Excel files. What should you do first in Power BI?

A Only connect to Excel files because cloud databases are not supported.

B Connect to both the cloud database and Excel files to get all data needed.

C Start creating visuals without connecting to any data source.

D Copy data manually from Excel to Power BI without connecting.

💡 Hint

Think about where your data lives and how Power BI can access it.

Power BI can connect to many data sources including cloud databases and Excel files. Connecting to all relevant sources ensures you have complete data for analysis.

❓ dax_lod_result

advanced

DAX measure output after connecting data

After connecting a sales table with columns: Product, Quantity, and Price, you create this measure:

Total Sales = SUMX(Sales, Sales[Quantity] * Sales[Price])

What will be the result if the Sales table has these rows?

Product | Quantity | Price
A       | 2        | 10
B       | 3        | 15
C       | 1        | 20

A 45

B 50

C 85

D Syntax Error

💡 Hint

Multiply quantity by price for each row, then add all.

Total Sales sums Quantity * Price for each product: (2*10)+(3*15)+(1*20) = 20+45+20 = 85.

🔧 Formula Fix

advanced

Identify the error in data connection step

You try to connect Power BI to a SQL Server database but get an error. Which option is the most likely cause?

A The server name or credentials are incorrect.

B Power BI does not support SQL Server connections.

C You must import data manually by copying and pasting.

D Power BI only connects to Excel files, not databases.

💡 Hint

Check the connection details carefully.

Incorrect server name or login details cause connection errors. Power BI supports SQL Server connections.

❓ visualization

expert

Best visualization after connecting multiple data sources

You connected sales data from a database and customer demographics from Excel. You want to show total sales by customer age group. Which visualization is best?

A A bar chart showing total sales for each age group.

B A pie chart showing sales by product category only.

C A table listing all customers without grouping.

D A line chart showing sales over time without age groups.

💡 Hint

Think about how to compare sales across age groups visually.

A bar chart clearly compares total sales across different age groups, making it easy to see differences.