0
0
Power BIbi_tool~20 mins

Data source and dataset in Power BI - Practice Problems & Coding Challenges

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Challenge - 5 Problems
🎖️
Data Source and Dataset Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
🧠 Conceptual
intermediate
2:00remaining
Understanding Data Sources in Power BI

Which of the following best describes a data source in Power BI?

AA location or service where raw data is stored and accessed by Power BI.
BA calculated column added to a dataset.
CA filter applied to data to show specific results.
DA visual report created from data in Power BI.
Attempts:
2 left
💡 Hint

Think about where Power BI gets its data from before processing.

❓ data_output
intermediate
2:00remaining
Dataset Content After Import

After importing data from an Excel file into Power BI, what does the dataset contain?

AThe raw Excel file stored inside Power BI.
BOnly the connection details to the Excel file without any data.
CA set of visual charts created automatically from the Excel data.
DThe imported tables and their data ready for analysis and visualization.
Attempts:
2 left
💡 Hint

Consider what Power BI uses to build reports after importing.

🔧 Formula Fix
advanced
2:00remaining
Identifying the Error in Data Refresh

Power BI fails to refresh data from a SQL Server data source. Which option shows the most likely cause?

AThe Power BI desktop version is outdated but data refresh always works offline.
BThe SQL Server credentials used in Power BI are incorrect or expired.
CThe dataset was created from an Excel file, not SQL Server.
DThe Power BI report has too many visuals on one page.
Attempts:
2 left
💡 Hint

Think about what is needed to access data from a database during refresh.

🎯 Scenario
advanced
2:00remaining
Choosing the Right Data Source for Real-Time Data

You need to build a Power BI report that shows real-time sales data updating every minute. Which data source type is best?

AA streaming dataset connected to a live API providing sales data.
BAn Excel file uploaded manually once a day.
CA static CSV file stored on a local computer.
DA PowerPoint file with sales charts.
Attempts:
2 left
💡 Hint

Real-time means data updates automatically and frequently.

📊 Formula Result
expert
2:00remaining
Power Query M Code Output for Dataset Preview

Given this Power Query M code snippet that loads data from a CSV file, what will be the output of Table.RowCount(Source) if the CSV has 100 rows?

let
  Source = Csv.Document(File.Contents("sales.csv"),[Delimiter=",", Columns=5, Encoding=1252, QuoteStyle=QuoteStyle.None])
in
  Table.RowCount(Source)
A100
B0
CError: Table.RowCount expects a table but got a list
D101
Attempts:
2 left
💡 Hint

Consider the type returned by Csv.Document and what Table.RowCount expects.