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

Scheduled Refresh and Gateway

Power BI reports often depend on data that changes regularly. Scheduled refresh helps keep imported data in a semantic model up to date without requiring a user to refresh it manually every time. A data gateway can provide a secure connection between Power BI Service and supported data sources located inside a private network.

Learning Objectives

  • Understand semantic model refresh in Power BI Service.
  • Differentiate manual refresh from scheduled refresh.
  • Understand the purpose of a data gateway.
  • Identify when an on-premises data gateway is needed.
  • Configure and test refresh settings.
  • Troubleshoot common refresh and gateway problems.

1. What Is Data Refresh?

Data refresh updates the imported data stored in a Power BI semantic model by retrieving data from its configured source. For example, if a sales database receives new transactions each day, a refresh can bring those transactions into the semantic model so reports can display updated results.

Refreshing data does not necessarily mean that the report design changes. It usually updates the data used by the existing visuals, measures, and report pages.

Data Source Database or file New transactions Refresh Semantic Model Updated data Tables and measures Report Updated results Refresh the model so reports can use the latest imported data.

2. Manual Refresh vs. Scheduled Refresh

Feature Manual Refresh Scheduled Refresh
How it starts A user starts a refresh when needed. Power BI Service starts refreshes according to a configured schedule.
Typical use Testing, troubleshooting, or updating data on demand. Regular updates such as daily or weekly reporting.
User involvement Requires someone to initiate the operation. Runs automatically when the schedule and dependencies are configured correctly.
Monitoring Check the result after initiating refresh. Review refresh history and failure notifications where configured.
Best Practice: Choose a refresh schedule that matches the business need. A report used for daily summaries may not need hourly refreshes. Consider source-system load, data freshness requirements, and the refresh limits applicable to your Power BI license and capacity.

3. What Is Scheduled Refresh?

Scheduled refresh allows a semantic model to refresh automatically at configured times. Before setting it up, confirm that the model's data sources are supported, credentials are valid, and any required gateway connection is available.

General Setup Procedure

  1. Publish the Power BI Desktop report to the appropriate workspace.
  2. Open Power BI Service and locate the semantic model associated with the report.
  3. Open the semantic model's settings.
  4. Review the data source credentials and connection configuration.
  5. Configure the gateway connection if the source requires one.
  6. Locate the scheduled refresh settings.
  7. Enable refresh and choose the available frequency and times.
  8. Apply the settings and check the refresh history after the scheduled run.
1 Configure Choose frequency and refresh times 2 Refresh Service runs the scheduled operation 3 Monitor Review refresh history and errors A schedule automates refresh attempts, but it does not guarantee success.

4. What Is a Data Gateway?

A data gateway provides a bridge between Power BI Service and supported data sources that Power BI Service cannot access directly. It is commonly used when data is stored on a local server or inside a private corporate network.

A gateway allows the service to communicate with the configured source through an approved connection. It does not replace source credentials, database permissions, or network access requirements.

Power BI Service Refresh Request Semantic Model Secure link Gateway Installed and online Configured connection Query Private Data The gateway must be online and configured for the required data source.

5. Types of Gateway and When They Are Needed

Gateway Option Typical Purpose
On-premises data gateway Connects Power BI Service to supported data sources inside a local or private network.
Standard mode Supports shared gateway use across multiple users and workloads, subject to configuration and permissions.
Personal mode Designed for individual use with supported Power BI refresh scenarios and has more limited sharing capabilities.
Direct cloud connection Some cloud data sources can be accessed directly without an on-premises gateway, depending on the source and configuration.
Remember: Not every Power BI data source requires a gateway. Check the source type, network location, connectivity method, and current Power BI requirements before installing one.

6. Installing and Configuring a Gateway

A gateway should be installed on a computer or server that can reach the required data sources and remain available during scheduled refreshes. In organizational environments, coordinate installation with the administrator responsible for infrastructure and data access.

General Configuration Workflow

  1. Identify the data source that Power BI Service needs to access.
  2. Confirm whether the source requires a gateway.
  3. Choose the appropriate gateway mode for the intended use.
  4. Install the supported gateway software on an appropriate machine.
  5. Sign in and register the gateway according to the setup instructions.
  6. Configure the data source connection and required credentials.
  7. Grant the required users permission to use the gateway connection.
  8. Map the published semantic model to the correct gateway data source.
  9. Test connectivity and run a refresh to confirm that the setup works.
Security Note: Install gateways only on trusted, managed systems. Keep the software updated, restrict administrative access, and use approved credentials. Avoid sharing database passwords or gateway recovery information with unauthorized users.

7. Configuring Scheduled Refresh Settings

After the semantic model has valid credentials and any required gateway connection, configure its refresh schedule in Power BI Service. The options displayed depend on the source, model, capacity, and organizational settings.

Setting What to Review
Refresh frequency Choose a supported schedule that meets the reporting requirement.
Time zone Check the time zone used when interpreting scheduled refresh times.
Data source credentials Confirm that the configured account is valid and authorized.
Gateway connection Verify that the correct gateway and data source mapping are configured.
Refresh history Review the status, duration, and error details of refresh attempts.
Notifications Configure available failure notifications so issues can be addressed.

8. Common Refresh and Gateway Problems

Problem Possible Cause Suggested Solution
Scheduled refresh fails because of credentials. The password changed, expired, or lacks the required permissions. Update the data source credentials and test the connection.
Gateway appears offline. The host computer is unavailable or gateway software is not running correctly. Check the host, gateway service, network connectivity, and gateway status.
Power BI cannot find the required gateway source. The semantic model is not mapped to the correct configured data source. Review the gateway data source and semantic model mapping.
Refresh takes too long. The source query is slow, the model is large, or the source system is under load. Review query performance, model design, source capacity, and refresh timing.
Refresh works locally but fails online. The service may have different credentials, network access, or connection settings. Review cloud credentials, gateway requirements, and source connectivity.
New records do not appear in a report. The refresh has not completed, failed, or the report uses a different data path. Check refresh history, source data, filters, and the model configuration.

9. Practical Exercise

Task: Configure a Refresh Plan for a Sales Report

Use a practice Power BI report connected to a data source that you are authorized to access.

  1. Publish the Sales Performance report to your practice workspace.
  2. Identify the data source used by the semantic model.
  3. Determine whether a gateway is required for that source.
  4. Review the data source credentials in Power BI Service.
  5. Configure a gateway connection if the source requires one.
  6. Set an appropriate refresh schedule using the available options.
  7. Run a test refresh and confirm that it completes successfully.
  8. Review the refresh history and record the result.
  9. Simulate a troubleshooting scenario by reviewing the settings that could cause a failure.

Expected outcome: A documented refresh configuration with valid source access, the correct gateway setup where needed, and a verified refresh result.

10. Knowledge Check

Question 1: What is the purpose of scheduled refresh?

A. To redesign report pages automatically

B. To update imported model data according to a configured schedule

C. To remove all report filters

D. To create a new workspace every day

Question 2: When is an on-premises data gateway commonly needed?

A. When connecting the service to a supported source inside a private network

B. Whenever a report contains a card visual

C. Whenever a report uses a blue theme

D. Only when creating a report title

Question 3: What should you check when scheduled refresh fails?

A. Only the report background color

B. Only the number of report pages

C. Credentials, gateway connectivity, source access, and refresh history

D. The desktop wallpaper

Show Answers
  1. B — Scheduled refresh updates imported model data at configured times.
  2. A — A gateway commonly provides access to supported private-network data sources.
  3. C — These settings help identify common refresh failures.

Summary

Scheduled refresh helps keep imported Power BI semantic model data up to date by running refresh operations at configured times. Before enabling it, verify the data source credentials, connection settings, and refresh requirements.

A data gateway provides a connection between Power BI Service and supported data sources that are not directly accessible from the service, such as sources inside a private network. The gateway must be configured correctly and available when refresh is required.

After configuring refresh, review refresh history and troubleshoot any errors involving credentials, gateway availability, connectivity, or source performance. A reliable refresh process helps reports present timely and trustworthy business information.