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

Data Source Credentials and Refresh

Learn how to configure data source credentials, understand privacy levels, refresh imported data, review refresh history, and troubleshoot common data access problems in Power BI.

1. What Are Data Source Credentials?

Data source credentials are authentication details that Power BI uses to access a data source. Depending on the source, authentication may use an organizational account, a username and password, an API key, or anonymous access.

Why Credentials Matter

  • They allow authorized access to protected data.
  • They help Power BI retrieve data during refresh operations.
  • They control which account is used to connect to a source.
  • They help organizations apply access and security policies.
Power BI Connection request Uses credentials Authentication Verify identity Check permission Data Source Access permitted Return data Valid credentials do not replace the source's access permissions.

Visual 1: Power BI authenticates with a source before accessing protected data.

Best practice: Use approved credentials and grant only the permissions required for the report.

2. Configuring Credentials in Power BI Desktop

Power BI Desktop may prompt you for authentication when you connect to a data source. You can also review saved source permissions through the application's data source settings.

Steps to Manage Credentials

  1. Open Power BI Desktop.
  2. Select File → Options and settings → Data source settings.
  3. Select the relevant data source from the list.
  4. Choose the available option to edit permissions or clear permissions.
  5. If needed, reconnect and select the correct authentication method.
  6. Enter the required credentials and test the connection.
  7. Refresh the data to verify that access works.

Common Authentication Methods

Method Typical Use Consideration
Anonymous Public sources without sign-in requirements Use only when the source permits public access.
Organizational account Supported work or school services The account must have permission to access the resource.
Basic Sources that support a username and password Follow the source provider's security requirements.
Web API Supported API key authentication Protect keys and follow the API provider's instructions.
Important: Available authentication methods vary by connector. Some sources require a specific sign-in flow or custom API implementation.

3. Understanding Data Privacy Levels

Privacy levels help Power Query determine how data from different sources may be combined. They are particularly important when a query uses information from more than one source.

Privacy Level Description Example
Public Data intended to be shared publicly A public reference dataset.
Organizational Data intended to be shared within an organization An approved internal reporting source.
Private Sensitive data that should be isolated from other sources A personal or confidential business dataset.

The correct setting depends on the source's sensitivity and your organization's policies. Privacy levels are not a replacement for source permissions, access controls, or appropriate data handling.

1 Public Publicly available data Suitable for public use 2 Organizational Internal business data Follow company policies 3 Private Sensitive information Keep appropriately isolated Assign each source according to its actual sensitivity.

Visual 2: Privacy levels classify sources according to their intended use and sensitivity.

4. What Is Data Refresh?

Data refresh retrieves updated data from the connected sources and updates the imported data in the Power BI semantic model when the refresh completes successfully.

Types of Data Updates

  • Manual refresh: Start a refresh when needed.
  • Scheduled refresh: Configure supported refresh times in the Power BI Service.
  • DirectQuery: Queries the underlying source when data is requested, subject to the connector and model behavior.
  • Automatic page refresh: Available for supported scenarios and configurations; it is not the same as refreshing imported model data.
Power BI Semantic Model Imported data Manual Refresh User starts the refresh Scheduled Refresh Service runs the schedule Successful refresh depends on credentials and source availability.

Visual 3: Imported model data can be refreshed manually or through a configured schedule.

5. Configure Scheduled Refresh in the Power BI Service

After publishing a report, the semantic model may require credentials and refresh settings to be configured in the Power BI Service.

Typical Configuration Steps

  1. Publish the report from Power BI Desktop.
  2. Open the relevant workspace in the Power BI Service.
  3. Locate the semantic model associated with the report.
  4. Open its settings.
  5. Review data source credentials and connection settings.
  6. Configure supported credentials and any required gateway connection.
  7. Open the refresh section and enable a schedule if available.
  8. Select suitable refresh times and apply the configuration.
  9. Run or wait for a refresh, then review the result.
Note: Available options, refresh frequency, gateway requirements, and limits depend on the connector, licensing, capacity, and tenant configuration.

6. Understanding Gateway Requirements

A data gateway may be needed when the Power BI Service must reach a data source that is available only within a private network or on a local computer. Some cloud sources can be accessed directly without an on-premises gateway.

When a Gateway May Be Required

  • The data source is hosted on an internal company network.
  • The source is a local server that the Power BI Service cannot access directly.
  • The connector or connection setup requires a gateway.
  • The gateway must be online and configured with appropriate source credentials.
Power BI Service Cloud environment Refresh request Data Gateway Secure connection Configured access Internal Source Database or server Returns data A gateway is needed only for supported scenarios that require one.

Visual 4: A gateway can provide a configured route between the cloud service and an internal data source.

7. Reviewing Refresh History

Refresh history helps identify whether a refresh succeeded, failed, or took longer than expected. When an error occurs, review the displayed details before changing the connection.

Refresh Status Possible Meaning Recommended Action
Completed The refresh finished successfully. Confirm that the expected data is available.
Failed The refresh encountered an error. Read the error details and check access, credentials, and source availability.
Long-running The source or query may be slow. Review query efficiency, source performance, and response size.
Credentials error Authentication may be missing or expired. Update the supported credentials and retry.
Gateway error The gateway may be unavailable or misconfigured. Check gateway status, mapping, and permissions.

8. Common Problems and Solutions

Problem: Credentials Are Rejected

Verify the authentication method, account permissions, and whether the credentials have expired. Confirm that the correct data source is selected in the settings.

Problem: Refresh Works in Desktop but Fails Online

Check the semantic model's service credentials, gateway requirements, source accessibility, and supported connector behavior. Desktop access does not automatically configure service refresh.

Problem: Refresh Is Slow

Review Power Query steps, the amount of data retrieved, network performance, source response times, and query folding where supported.

Problem: Some Rows Are Missing

Check source filters, API pagination, date ranges, permissions, and query steps that may remove records.

9. Practical Exercise

Exercise: Configure and Verify Refresh

Scenario: A report imports monthly sales data and must remain up to date.

  1. Open a Power BI Desktop report connected to an available practice data source.
  2. Review Data source settings and identify the authentication method.
  3. Verify that the source credentials work.
  4. Review the privacy level and select the appropriate setting for the source.
  5. Refresh the data in Power BI Desktop.
  6. Publish the report to a workspace where you have permission.
  7. Review the semantic model settings in the Power BI Service.
  8. Configure supported credentials and gateway settings if required.
  9. Set a refresh schedule if the workspace and model support it.
  10. Review refresh history and record the result.

Expected outcome: A report with verified source access and a documented refresh configuration.

10. Knowledge Check

Question 1: What is the main purpose of data source credentials?

A. To format charts
B. To authenticate access to a data source
C. To change report themes
D. To create relationships automatically

Question 2: What do privacy levels help Power Query manage?

A. Chart colors
B. Page size
C. How data from different sources may be combined
D. Font styles

Question 3: Why might a gateway be required?

A. To create a title
B. To access a supported internal data source from the Power BI Service
C. To format a table
D. To rename a measure

Question 4: Where can you investigate a failed service refresh?

A. The report theme gallery
B. The visual formatting pane
C. The semantic model refresh history and error details
D. The page navigation menu

View Answers
  1. B — To authenticate access to a data source.
  2. C — How data from different sources may be combined.
  3. B — To access a supported internal data source from the Power BI Service.
  4. C — The semantic model refresh history and error details.

Summary

In this lesson, you learned how Power BI uses data source credentials to authenticate access, how to manage authentication settings, and how privacy levels help control the combination of data from different sources.

You also explored manual and scheduled refresh, gateway requirements, refresh history, and common troubleshooting techniques for keeping reports up to date.