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

Web and Online Data Sources

Learn how to connect Power BI Desktop to web pages, online files, public datasets, and web APIs. Understand URLs, structured web data, JSON responses, authentication, and data refresh considerations.

1. Introduction to Web Data Sources

Web data sources provide information through websites, downloadable files, and online services. Power BI can connect to supported web sources and import data that can be transformed, modeled, and visualized.

Common Online Sources

  • HTML tables published on web pages.
  • CSV and Excel files hosted online.
  • JSON files and API responses.
  • Cloud-hosted business datasets.
  • Supported online services and connectors.
Web Page HTML tables Online Files CSV / Excel / JSON Web API Structured responses Power BI Get Data Power Query Report Model Visuals

Visual 1: Online data is connected, prepared, modeled, and used in reports.

2. Connecting to a Web Page

The Web connector can retrieve supported web content. If a page contains recognizable tables, Power BI may display them in the Navigator window. The available results depend on the page structure and access requirements.

Steps to Connect

  1. Open Power BI Desktop.
  2. Select Home → Get Data → Web.
  3. Enter the URL of the intended web resource.
  4. Choose the appropriate connection option if prompted.
  5. Review the available tables or data objects in Navigator.
  6. Select a suitable item and choose Transform Data or Load.
  7. Inspect column names, data types, and sample rows.
Get Data Choose Web Enter URL Connect Navigator Select data Transform Clean data Load Build report Always validate the selected data before building visuals.

Visual 2: The typical workflow for connecting to a web resource.

Best practice: Use a stable, trusted URL that returns the required data consistently. A page designed for human browsing may not expose data in a format that the connector can reliably extract.

3. Understanding URLs and Web Content

A URL identifies a resource on the internet. Before connecting, verify that the address points to the intended page, file, or API endpoint.

Example URL Structure

https://example.com/data/sales.csv
  • https:// identifies the secure web protocol.
  • example.com identifies the host.
  • /data/sales.csv identifies the resource path.
Resource Type Typical Content What to Check
HTML page Page text and possibly tables Whether the required data is exposed in a supported structure
CSV file Rows and columns of delimited values Delimiter, encoding, headers, and file availability
JSON endpoint Objects, arrays, and properties Response structure, authentication, and pagination
Excel file Worksheets and tables File access, workbook structure, and correct URL

4. Introduction to Web APIs

An Application Programming Interface (API) allows software applications to request information or perform supported operations. Many APIs return data in JSON format. Power BI can consume suitable API responses when the endpoint, authentication method, and response format are supported.

Example API Request Concept

GET https://api.example.com/sales

This example represents a hypothetical endpoint. It is not a live service and will not return real sales data.

Example JSON Response

{ "sales": [ { "orderId": 1001, "region": "West", "amount": 2500 }, { "orderId": 1002, "region": "North", "amount": 1800 } ] }

In Power Query, JSON data may appear as records and lists. These structures can be expanded into a table so that fields such as orderId, region, and amount become columns.

JSON Response {"{"} "sales": [ {"{"} "orderId": 1001, "region": "West", "amount": 2500 {"}"} ] {"}"} Expand orderId region amount 1001 West 2500 1002 North 1800 Tabular data

Visual 3: Nested JSON objects can be expanded into rows and columns.

Important: APIs may require keys, tokens, specific headers, or pagination. Never place private credentials directly in a report description or share them in screenshots or source code.

5. Loading and Transforming Online Data

Online data often requires preparation before it is suitable for reporting. Use Power Query Editor to review the structure and apply repeatable transformation steps.

  1. Remove unnecessary columns.
  2. Promote the correct row to column headers when required.
  3. Set accurate data types for text, dates, whole numbers, and decimals.
  4. Expand records or lists in JSON responses when appropriate.
  5. Filter unwanted rows and handle missing values.
  6. Rename columns using clear business terms.
  7. Check the final table for errors and unexpected values.

Example: Preparing an Online Sales Table

Order ID Order Date Region Amount
1001 2026-01-05 West 2500
1002 2026-01-06 North 1800
1003 2026-01-07 South 3200

The Order Date column should use a date type, Amount should use a suitable numeric type, and Order ID should remain a stable identifier.

6. Authentication and Online Access

Some online sources are public, while others require a supported authentication method. The correct method depends on the service and connector.

Authentication Method Typical Use Important Consideration
Anonymous Public resources that do not require sign-in Use only when the resource is intended to be public.
Organizational account Supported work or school services Access depends on account permissions and service support.
Basic authentication Services that explicitly support a username and password Use secure connections and follow organizational policies.
Web API credentials APIs that support API key authentication through the connector Check the provider's security and credential requirements.

In Power BI Desktop, review the data source credentials settings when authentication fails. In the Power BI Service, refresh may also require credentials to be configured for the published semantic model.

7. Refreshing Online Data

Imported online data represents the content retrieved during a refresh. If the source changes, the report does not automatically reflect every change unless a refresh or another supported update mechanism occurs.

Online Source Updated data Refresh Retrieve data Updated Model Report data Refresh depends on access, credentials, and source availability. Configure and test refresh after publishing.

Visual 4: Refresh retrieves online data and updates the imported model when successful.

Refresh Checklist

  • Confirm that the source URL is still valid.
  • Verify credentials and permissions.
  • Check whether the endpoint is accessible from the Power BI Service.
  • Review refresh history for errors.
  • Check source limits, API throttling, and pagination behavior.
  • Test refresh after changing credentials or query steps.

8. Common Problems and Solutions

Problem Possible Cause Suggested Action
Access denied Missing credentials or insufficient permissions Verify access and configure supported credentials.
No tables appear The page does not expose recognizable tables Check the source format or use a suitable file or API endpoint.
Data format error Unexpected HTML, JSON, or file structure Inspect the response and adjust the query steps.
Refresh failure Expired credentials, changed URL, or unavailable service Review credentials, URL, service access, and refresh history.
Missing records Pagination, filters, or API limits Review the provider's documentation and confirm all pages are retrieved.
Slow response Large response or slow source service Reduce unnecessary data and optimize query steps where possible.

9. Practical Exercise

Exercise: Import and Prepare Online Sales Data

Scenario: A sales analyst needs to analyze regional sales from an online data source.

  1. Identify a trusted web resource that provides a suitable sample dataset.
  2. Use Get Data to connect to the resource.
  3. Inspect the available tables or response objects.
  4. Load the relevant data into Power Query Editor.
  5. Rename columns and set appropriate data types.
  6. Remove irrelevant fields and check for missing values.
  7. Load the prepared table and create a regional sales chart.
  8. Document any access or refresh requirements.

Expected outcome: A clean table that can support a simple regional sales report.

10. Knowledge Check

Question 1: Which Power BI feature is commonly used to connect to a supported web resource?

A. Get Data → Web
B. Format Painter
C. Manage Relationships only
D. Page Navigator

Question 2: What is JSON commonly used to represent?

A. Only images
B. Structured objects and arrays
C. Page formatting only
D. Power BI themes only

Question 3: Why may an online source require credentials?

A. To change chart colors
B. To grant authorized access to protected data
C. To create a measure automatically
D. To resize a report page

Question 4: What should you check when an API returns incomplete data?

A. Report background color
B. Visual title size
C. Pagination, filters, and API limits
D. Card border radius

View Answers
  1. A — Get Data → Web.
  2. B — Structured objects and arrays.
  3. B — To grant authorized access to protected data.
  4. C — Pagination, filters, and API limits.

Summary

Power BI supports several types of online data sources. The Web connector can retrieve supported web content. APIs commonly provide structured responses such as JSON. Power Query can expand and transform online data. Authentication and permissions must be configured appropriately. Published reports may require separate refresh configuration. Pagination, API limits, and source availability can affect completeness and refresh success.