Forum Discussion
ericjo
Helper III
Helper IIIPower BI Data Source credentials
I'm creating a report using SharePoint. I have a question about setting data source credentials in the Power BI Portal. 1. I see five authentication methods: Anonymous, Basic, OAuth2, Service Prin...
Hi ericjo,
Refer below table, hope this helps to understand:-
Privacy Level Description Use Case None No data isolation. Power BI can freely combine this source with others. Use for trusted, internal sources when you don’t need strict boundaries. Private Data is highly restricted — cannot be combined with other sources. Use for confidential data like HR or finance databases. Organizational Data is within your company’s domain — can be combined with other organizational sources. Use for SharePoint, internal SQL, etc. Public Data is freely shareable — can be combined with anything. Use for open data sources, like public APIs or websites. 🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
ericjoHelper III
Helper IIIThank you for your information, but since it only answers one of two questions,
I can't accept it as the solution. Is there a separate answer for question 1?
grazitti_sapna
Super User
Super UserHi ericjo,
Refer below table for Question no. 1
| Method | Description | Common Use | Notes |
| Anonymous | No credentials required | Public APIs / files | Not for SharePoint |
| Basic | Username password (Like we have credentials for SQL Database) | Legacy systems | Rarely used for M365 |
| OAuth2 | Login with Microsoft 365 | SharePoint Online / OneDrive | Recommended |
| Service Principal | Azure Active Directory app | Automation | Requires setup |
| Workspace Identity | Managed identity for Fabric workspace | Fabric to Fabric | New in Fabric |