When connecting Power BI to a SharePoint document library, which URL should you provide to ensure proper access?

easy📝 Conceptual Q2 of 15

Power BI - Getting Data

AThe root site URL without any folder or file path, e.g., https://company.sharepoint.com/sites/finance

BThe full path to a specific file inside the document library, e.g., https://company.sharepoint.com/sites/finance/Reports/Report1.xlsx

CThe URL including the '/Forms/AllItems.aspx' suffix of the document library

DA OneDrive personal folder URL, e.g., https://company-my.sharepoint.com/personal/username/Documents

Step-by-Step Solution

Solution:

Step 1: Identify the SharePoint site root URL
Power BI requires the root site URL to connect properly to the document library.
Step 2: Avoid using URLs pointing to specific files or views
URLs with '/Forms/AllItems.aspx' or pointing to individual files cause connection issues.
Final Answer:
The root site URL without folder or file path -> Option A
Quick Check:
Root site URL only [OK]

Quick Trick: Use the SharePoint site root URL, not file or view URLs [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