What is the primary difference between connecting Power BI to SharePoint Online and OneDrive for Business?

easy📝 Conceptual Q1 of 15

Power BI - Getting Data

AOneDrive requires a special connector, SharePoint does not.

BSharePoint Online connects to team sites, OneDrive connects to personal storage.

CSharePoint only supports Excel files, OneDrive supports all file types.

DOneDrive connections are read-only, SharePoint connections allow editing.

Step-by-Step Solution

Solution:

Step 1: Understand SharePoint and OneDrive roles
SharePoint Online is designed for team collaboration and stores files in team sites, while OneDrive for Business is personal cloud storage for individual users.
Step 2: Compare connection types in Power BI
Power BI connects to SharePoint team sites for shared files and to OneDrive for Business for personal files, reflecting their storage roles.
Final Answer:
SharePoint Online connects to team sites, OneDrive connects to personal storage. -> Option B
Quick Check:
Storage roles = SharePoint (team), OneDrive (personal) [OK]

Quick Trick: SharePoint = team files, OneDrive = personal files [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