Microsoft Power BI Power BI Administration and Security 1 — Questions and Answers
Question 1: What is the 'Power BI Admin Portal' used for?
- Building reports and dashboards
- Managing tenant-wide Power BI settings, usage metrics, capacity management, and governance controls (Correct answer)
- Configuring gateway connections
- Managing row-level security roles
Correct answer: Managing tenant-wide Power BI settings, usage metrics, capacity management, and governance controls
The Power BI Admin Portal allows Power BI administrators to configure tenant settings, manage Premium capacities, view audit logs, and control feature availability across the organization.
Question 2: What is 'Power BI Premium' and what is its main differentiator from Power BI Pro?
- Premium is the mobile version of Power BI Pro
- Premium provides dedicated cloud capacity, allowing report sharing with users who don't need individual Pro licenses (Correct answer)
- Premium removes the 1GB dataset size limit only
- Premium is required for using Power BI Desktop
Correct answer: Premium provides dedicated cloud capacity, allowing report sharing with users who don't need individual Pro licenses
Power BI Premium provides dedicated capacity in the cloud, enabling features like larger dataset sizes, more frequent refreshes, and allowing Free users to consume Premium workspace content without Pro licenses.
Question 3: What type of security in Power BI restricts access to specific columns in a dataset?
- Row-Level Security (RLS)
- Column-Level Security (CLS)
- Object-Level Security (OLS) (Correct answer)
- Field-Level Security (FLS)
Correct answer: Object-Level Security (OLS)
Object-Level Security (OLS) in Power BI allows you to restrict access to specific tables or columns so that unauthorized users cannot see those fields even in the report or data model.
Question 4: What is the 'Power BI Activity Log' used for by administrators?
- Tracking refresh errors in datasets
- Recording user activities (view report, export data, share, etc.) for auditing and governance purposes (Correct answer)
- Monitoring CPU usage of Power BI Premium capacity
- Logging DAX query execution times
Correct answer: Recording user activities (view report, export data, share, etc.) for auditing and governance purposes
The Power BI Activity Log records user activities such as viewing reports, exporting data, and sharing content, enabling administrators to audit usage and investigate security incidents.
Question 5: What is 'Azure Active Directory (AAD) integration' critical for in Power BI?
- Connecting Power BI to Azure SQL databases only
- Providing identity and access management for Power BI users, enabling SSO, conditional access, and MFA (Correct answer)
- Hosting Power BI reports in Azure
- Storing Power BI datasets in Azure Data Lake
Correct answer: Providing identity and access management for Power BI users, enabling SSO, conditional access, and MFA
Power BI relies on Azure Active Directory (now Microsoft Entra ID) for user authentication, single sign-on, role assignments, and enforcing conditional access policies like MFA.
Question 6: What does 'Tenant Setting: Export Data' control in the Power BI Admin Portal?
- Whether datasets can be exported to Azure
- Whether users are allowed to export data from Power BI visuals to Excel, CSV, or other formats (Correct answer)
- The maximum file size for exported reports
- Whether paginated reports can be exported
Correct answer: Whether users are allowed to export data from Power BI visuals to Excel, CSV, or other formats
The 'Export Data' tenant setting controls whether users in the organization can export underlying data from Power BI visuals to CSV or Excel files.
Microsoft Power BI Power BI Administration and Security 1
What is the 'Power BI Admin Portal' used for?