Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi all,
Just wondering if anyone can help me please. What is the minimum permissions required in order to use SharePoint as a data source, can a user have read permissions to a SharePoint Online list and still be able to connect to this as a data source using Power BI desktop?
Thanks!
Solved! Go to Solution.
Hi @Adam13Hylo
Testing on my site,It is possible to connect to Sharepoint resources with read permission in Power BI.
Admin-Office 365 Admin
User A- has a Power BI Pro account which is belong to the organization as Admin does
In Sharepoint online, Admin change the permission for User A as Read permission to the Home site,
User A can connect to the lists from that site (with only read permission) in Power BI Desktop.
Best Regards
Maggie
Hi @Adam13Hylo
Testing on my site,It is possible to connect to Sharepoint resources with read permission in Power BI.
Admin-Office 365 Admin
User A- has a Power BI Pro account which is belong to the organization as Admin does
In Sharepoint online, Admin change the permission for User A as Read permission to the Home site,
User A can connect to the lists from that site (with only read permission) in Power BI Desktop.
Best Regards
Maggie
Read permissions is all you need
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 2 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 5 | |
| 4 | |
| 4 |