Bird
0
0

If you connect Power BI to OneDrive for Business using the URL:

medium📝 Formula Result Q5 of 15
Power BI - Getting Data
If you connect Power BI to OneDrive for Business using the URL:
https://company-my.sharepoint.com/personal/username/Documents

What will Power BI load?
AOnly Excel files in the Documents folder
BFiles from the SharePoint team site Documents folder
CAll files in the user's OneDrive Documents folder
DNo files, connection will fail
Step-by-Step Solution
Solution:
  1. Step 1: Recognize OneDrive URL pattern

    The URL points to the personal OneDrive Documents folder of the user.
  2. Step 2: Understand Power BI connection behavior

    Power BI loads all files in the specified folder when connecting to OneDrive for Business.
  3. Final Answer:

    All files in the user's OneDrive Documents folder -> Option C
  4. Quick Check:

    OneDrive connection loads all files [OK]
Quick Trick: OneDrive URL loads all files in folder [OK]
Common Mistakes:
  • Confusing OneDrive with SharePoint team site
  • Assuming only Excel files load
  • Thinking connection will fail due to URL

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes