Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

Sharing and Permissions in Power BI

Power BI sharing allows report creators to make business insights available to other people. Permissions determine what recipients can view, share, edit, or manage. Correctly configuring access helps teams collaborate while protecting confidential business information.

Learning Objectives

  • Understand the different ways to share Power BI content.
  • Differentiate report sharing from workspace access.
  • Understand workspace roles and app audiences.
  • Learn how to review and manage permissions.
  • Apply security practices when distributing reports.
  • Troubleshoot common access and permission problems.

1. What Is Sharing in Power BI?

Sharing in Power BI allows authorized users to provide access to reports, dashboards, or other supported content. The available sharing options depend on the content type, workspace configuration, user permissions, organizational policies, and licensing.

Sharing does not necessarily give another person permission to edit the original report. Access to view content and access to modify or manage content are different responsibilities.

Sales Report Content Owner Grant access Permissions View or approved additional access Recipients Access permitted Grant only the access needed for the recipient's role.

2. Common Ways to Distribute Power BI Content

Method Purpose Typical Use
Direct sharing Grants specified users access to supported content. Sharing a report with a colleague or a small group.
Workspace access Provides access to workspace content according to the assigned role. Collaborating with report authors and analysts.
Power BI app Distributes a curated collection of content to an audience. Providing department-wide reporting.
Organizational sharing options Allow approved distribution methods under organizational policies. Sharing content with other approved teams or external partners where permitted.
Best Practice: Choose the sharing method according to the audience. Direct sharing may suit a small group, while an app may be easier to maintain when distributing a curated set of reports to many business users.

3. Understanding Permissions

Permissions define the actions a user is allowed to perform. Before sharing content, identify whether the recipient needs to view a report, collaborate on its development, or administer the workspace.

Permission Levels by Responsibility View Read and interact with permitted content Report Consumer Collaborate Create or modify content as permitted Content Contributor Administer Manage access and workspace settings Authorized Admin Actual capabilities depend on the specific permission and access method.

4. Workspace Roles and Access

Workspace roles are intended for people who need access to workspace content. The roles have different capabilities, so choose the role that matches the person's responsibilities.

Workspace Role General Capability Typical Assignment
Admin Manages workspace settings, access, and content. Workspace owner or authorized administrator.
Member Collaborates on content and performs many publishing activities. Team member with substantial content responsibilities.
Contributor Creates and edits content within the role's permitted capabilities. Report author or analyst.
Viewer Views workspace content without the same editing capabilities as authoring roles. Business user who needs read access.
Important: Workspace access is broader than access to a single report in many scenarios. Do not assign a workspace role simply because someone needs to view one report. Consider direct sharing or app distribution when those options better match the requirement.

5. How to Share a Report

The following is a general workflow for sharing a report from Power BI Service. The available options and labels may vary according to your account, permissions, licensing, and organizational policies.

Step-by-Step Procedure

  1. Sign in to Power BI Service using your authorized account.
  2. Open the workspace or location containing the report.
  3. Open the report you want to share.
  4. Select the available Share option.
  5. Enter the intended recipient or recipients.
  6. Review any available permission options carefully.
  7. Grant only the access required for the task.
  8. Send the invitation or complete the sharing action.
  9. Ask the recipient to confirm that the report opens correctly.
1 Select the report 2 Choose Share option 3 Set Access Review recipients Verify Recipient access Always confirm that the recipient has the intended level of access.

6. Sharing Through Power BI Apps

Apps can be useful when several people need access to the same curated collection of reports. Instead of individually distributing every item, a content owner can manage the app experience and its intended audience.

General App Distribution Workflow

  1. Open the workspace containing the required reports.
  2. Review which reports and dashboards should be available to the audience.
  3. Create or update the app using the available workspace options.
  4. Configure the app's navigation and selected content.
  5. Set the intended audience and applicable access options.
  6. Publish or update the app.
  7. Verify access using an authorized test account where possible.
When to use an app: Consider an app when a department needs a consistent collection of reports and dashboards. It can provide a cleaner consumption experience than granting every user broad workspace permissions.

7. Report Permissions and Data Permissions

Access to a report and access to the underlying data are related but distinct concepts. A user may be able to open a report but still encounter a data-access issue if the semantic model or source permissions are not configured correctly.

Permission Area What It Controls What to Verify
Report access Whether a user can open and interact with the report. Confirm the intended recipient has permission to view it.
Workspace access Whether a user can access workspace content and perform role-based actions. Confirm the assigned role is appropriate.
Semantic model access Access to model data and supported model operations. Check model permissions and applicable security rules.
Source credentials Whether Power BI can connect to the underlying data source. Review credentials, gateway settings, and source permissions.
Row-level security Which rows of data a user is allowed to see when the security model applies. Validate role definitions and user assignments.
Security Note: Hiding a visual, report page, or column is not a replacement for data security. Use appropriate permissions and supported security features to protect confidential information.

8. Reviewing and Removing Access

Permissions should be reviewed when a person changes teams, leaves a project, or no longer needs the report. Removing access from one location may not remove access granted through another workspace, app, group, or sharing mechanism.

Access Review Checklist

  • Identify the report owner and workspace administrator.
  • Review who can access the report and the workspace.
  • Check app audience assignments and group-based access where applicable.
  • Confirm that external sharing follows organizational policy.
  • Remove permissions that are no longer required.
  • Review semantic model permissions and security role assignments.
  • Test access after making permission changes.
  • Keep a record of important access changes where required.

9. Common Sharing Problems

Problem Possible Cause Suggested Solution
A recipient cannot open the report. Missing access, licensing restrictions, or organizational policy. Check the sharing method, permissions, and applicable licensing.
A user can view but cannot edit. The user has view-only access or a role without the required editing capability. Review the required task and assign suitable permissions only if necessary.
A report opens but displays a data error. Semantic model access, source credentials, or refresh configuration may be incorrect. Review model permissions, credentials, gateway configuration, and refresh status.
A user sees more workspace content than expected. The assigned workspace role provides broader access than needed. Review the role and consider a more suitable sharing method.
A user still has access after one permission is removed. Access may have been granted through another group or sharing path. Review all applicable access locations and inherited group memberships.

10. Practical Exercise

Task: Share a Sales Performance Report Securely

Use a practice workspace and test users that you are authorized to manage. Do not use confidential production data for this exercise.

  1. Publish a Sales Performance report to a practice workspace.
  2. Identify one user who needs to view the report.
  3. Identify one user who needs to help maintain the report.
  4. Choose an appropriate sharing method for each user.
  5. Grant the minimum permissions needed for each task.
  6. Test whether the viewer can open the report.
  7. Verify that the content maintainer has the necessary editing access.
  8. Review semantic model access and any applicable security rules.
  9. Remove test access when the exercise is complete, if appropriate.

Expected outcome: The viewer can access the intended report, the maintainer has the required capabilities, and neither user receives unnecessary permissions.

11. Knowledge Check

Question 1: What is the main purpose of permissions in Power BI?

A. To change chart colors automatically

B. To control what users can access and do

C. To refresh every data source every minute

D. To rename every workspace

Question 2: Which option is often useful for distributing a curated collection of reports to a department?

A. Power BI app

B. Desktop wallpaper

C. Local text file only

D. Chart title

Question 3: What is the recommended approach to assigning access?

A. Give every user administrator access.

B. Give access to everyone without review.

C. Grant only the permissions required for the user's responsibilities.

D. Use hidden report pages instead of security controls.

Show Answers
  1. B — Permissions control what users can access and do.
  2. A — An app can distribute selected content to a department audience.
  3. C — Grant the minimum permissions needed for each responsibility.

Summary

Sharing and permissions help Power BI users collaborate while protecting business information. Reports can be distributed through direct sharing, workspace access, apps, and other approved organizational methods. Each method has different access and management implications.

Workspace roles support collaboration, while report and app access options help provide content to intended audiences. Access to a report does not automatically resolve every semantic model, source credential, or data-security requirement.

Review permissions regularly, grant only the access required for each person's responsibilities, and test the recipient experience after making changes. Use appropriate security controls rather than relying on hidden visuals or pages to protect sensitive data.