You want to combine sales data from multiple Excel files stored in OneDrive. How should you connect these in Power BI for automatic updates?

hard📝 Scenario Q9 of 15

Power BI - Getting Data

AConnect to the OneDrive folder as a data source using 'Get Data' and enable refresh

BDownload files locally and connect each manually without refresh

CCopy data from each file into a single Excel file and connect once

DCreate reports without connecting to OneDrive files

Step-by-Step Solution

Solution:

Step 1: Identify the best method to connect multiple files in OneDrive
Connecting to the OneDrive folder allows Power BI to access all files and update automatically.
Step 2: Understand the benefit of enabling refresh for automatic updates
Enabling refresh ensures the report reflects changes in files without manual intervention.
Final Answer:
Connect to the OneDrive folder as a data source using 'Get Data' and enable refresh -> Option A
Quick Check:
Folder connection + refresh = automatic updates [OK]

Quick Trick: Use folder connection for multiple files with refresh [OK]

Common Mistakes:

Master "Getting Data" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes