Lecture Notes: Power BI Service Questions

Introduction

• Welcome to part 4 of the Power BI series on Learn With Gigs.
• Recommended to watch the first three parts for better understanding.

Common Interview Questions

1. Difference between User Principal Name (UPN) and User Name DAX Functions

• Row Level Security (RLS): Restricts data based on the logged-in user.
  • Two types:
    • Static Row Level Security
    • Dynamic Row Level Security
• User Principal Name (UPN): Shows the username of the currently logged user in both Power BI Desktop and Service.
• User Name:
  • In Power BI Desktop: Shows the desktop name.
  • In Power BI Service: Shows correct credentials.
• Preference: Use User Principal Name for consistency across both platforms.

2. Difference between Power BI Pro and Premium License

• Power BI Pro:
  • Used by developers to create and publish reports.
  • Access to all content creation and interaction features.
• Power BI Premium:
  • Licensing based on dedicated capacity.
  • Content can be viewed without additional per-user cost.

3. What are Data Flows and Why Do We Want Them?

• Data Flows: Live queries that run independently within Power BI Service.
• Reasons for Use:
  • Reusable queries across multiple reports (desktop or service).
  • Ability to run ETL processes on a specific schedule.
  • Integrate, transform, and enrich data.

4. Data Gateway and Its Types

• Data Gateway: Acts as a bridge connecting local data on a machine/server to the Power BI service.
• Types of Data Gateways:
  • Personal Mode Gateway:
    • Used by individual users; not shared with other applications or services.
    • Supports scheduled refresh only.
  • Enterprise Mode Gateway:
    • Shared and used by multiple users; integrates with Power BI, Power Apps, Flow, etc.
    • Supports scheduled refresh and live queries.

5. Different Access Levels in a Workspace

• Access Levels:
  • Admin:
    • Owns/manages workspace; can create/delete workspaces with full control.
  • Member:
    • Has report development capabilities, can share reports, manage gateways, and give Contributor and Viewer access.
  • Contributor:
    • Contributes by modifying and publishing reports; can only give Viewer access.
  • Viewer:
    • Business/end users with access to view reports only; cannot modify them.

Conclusion

• Thank you for watching!
• Encouragement to subscribe and stay tuned for upcoming videos on DAX section.