Forum Discussion
Power BI Data Source credentials
- 9 months ago
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!
Hey ericjo ,
I did some digging and you were right the documentation for authentication types were all over the place.
For your first question, here are a few docs you can refer to (some are from Power Query or Power Apps docs but the concept is mostly similar in the platform)
- This should cover Anonymous, Basic, OAuth2: https://learn.microsoft.com/en-us/connectors/custom-connectors/connection-parameters
- Service principal is basically a robot user that is used in automating things. I have used them to just authenticate to workspaces and automatically deploy reports in a CICD framework. This should be a good read about it: https://medium.com/@kinsun_67689/creating-an-azure-app-or-service-principal-to-call-power-bi-rest-api-c8d604c00720
- This is for the workspace identity: https://learn.microsoft.com/en-us/fabric/security/workspace-identity
Well for privacy level, there was luckily a comprehensive doc:
https://learn.microsoft.com/en-us/power-query/privacy-levels
Hope it helps!