Forum Discussion
Power BI Data Source credentials
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!
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!
Thank 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?Hi 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
