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

Power BI Settings and Options

Learn how to configure Power BI Desktop preferences, manage regional settings, control preview features, review data-loading options, and understand security-related settings.

1. Learning Objectives

Power BI Desktop provides several settings that help users customize their working environment and control how reports and data behave. Understanding these options helps you work more efficiently and avoid common configuration problems.

By the end of this lesson, you will be able to:

  • Locate the Options and settings menu.
  • Understand global and current-file settings.
  • Recognize data-loading and query-related options.
  • Understand regional and language preferences.
  • Identify preview features and their limitations.
  • Review privacy, security, and data-source permissions.
  • Apply settings carefully and verify their effects.

2. Opening the Options and Settings Menu

Power BI Desktop includes an Options dialog where users can customize different aspects of the application. The available categories may vary depending on the installed version and enabled features.

To open the settings, start Power BI Desktop and look for the File menu. Open the Options and settings section, then select Options. Review the available categories before changing any configuration.

Power BI Desktop File Open Save Export Options and settings Options Manage application preferences Options Dialog Data Load Regional Settings Security and Privacy Other Preferences

Simplified navigation diagram. Menu labels and locations may differ by version.

Practical Tip: Before changing a setting, read its description and determine whether it applies to all reports or only to the current file.

3. Global Settings and Current File Settings

Power BI settings can apply to the application as a whole or to an individual report. Knowing the difference is important when working on multiple projects.

Global Settings Current File Settings Application Preferences Default Behaviors May affect multiple reports Report-Specific Preferences File-Level Configuration Applies to the current report

Conceptual comparison of application-wide and report-specific configuration.

Setting Type Meaning Example
Global Applies across the Power BI Desktop environment. Application preferences or default behaviors.
Current file Applies to the report currently being edited. File-level data-loading or report configuration options.

Classroom Example

Samadhan is preparing reports for two departments. He changes an application-wide preference and then opens another report. Depending on the preference, the change may affect his wider Power BI Desktop environment.

Pradnya changes a setting that belongs to one report. That configuration is intended for the current file rather than automatically applying to every report.

4. Data Loading and Query-Related Options

Data-loading settings can influence how Power BI processes imported data, handles relationships, and manages certain behaviors during model preparation. Exact options depend on the Power BI Desktop version and the selected data source.

Common Areas to Review

  • Data loading: Review available options related to loading data into the model.
  • Relationships: Check options that influence how relationships are detected or managed, when available.
  • Query evaluation: Understand how query changes are processed during data preparation.
  • Background processing: Review any available background-loading or preview-related options.
  • Model size: Remember that imported data volume and column choices can affect report memory use and performance.
Data Source Excel or Database Power Query Transform Data Data Model Load Data Report Visuals Settings can influence parts of this workflow.

Simplified workflow from the source to a report.

Important: Do not change several data-loading options at once without understanding their purpose. Make one change, test the report, and verify the result.

5. Regional Settings and Language Preferences

Regional settings are important when reports contain dates, numbers, currency values, or text that uses different regional conventions. Incorrect interpretation of regional formats can lead to confusing results.

Data Type Example What to Check
Date 04/05/2026 Confirm whether the source interprets this as April 5 or May 4.
Decimal Number 1250.75 Check decimal separators and source formatting.
Currency ₹25,000.00 Confirm the intended currency and number format.
Text Encoding Names containing special characters Check that imported text displays correctly.

Example: Date Interpretation

Samiksha imports a CSV file containing the value 04/05/2026. Depending on the regional convention used by the source and import process, the date may be interpreted differently.

She should verify the source format and select the correct data type and locale when transforming the column in Power Query, if required.

Best Practice: Validate dates and numeric values after import. Changing a display format alone does not always correct an incorrectly interpreted underlying value.

6. Preview Features and Experimental Options

Some Power BI Desktop versions provide preview or experimental features. These features may be available for testing before becoming part of the standard experience.

Standard Features Intended for regular use Commonly available options Suitable for routine workflows Preview Features May change over time Availability may vary Test before production use

Preview features may have different stability and support characteristics.

Guidelines for Preview Features

  • Read the feature description before enabling it.
  • Check whether a restart is required.
  • Test the feature in a non-critical report first.
  • Keep a backup of important project files.
  • Review current product documentation for known limitations.
Remember: Preview-feature availability changes between Power BI releases. Do not assume that every user will see the same list of options.

7. Security, Privacy, and Data Source Permissions

Power BI reports often use business data, student information, sales records, or financial details. Configuration choices should support appropriate access control and data protection.

Important Security Practices

  • Credentials: Use the correct credentials for each data source.
  • Privacy levels: Review privacy-level settings when combining data sources.
  • Permissions: Confirm that you are authorized to access and use the data.
  • Sensitive information: Avoid exposing confidential data in report screenshots, exports, or shared files.
  • Data sharing: Verify recipient permissions before distributing reports.
  • Organizational policies: Follow your organization's approved data-handling rules.
Practical Tip: Never share passwords or database credentials inside a report, screenshot, tutorial example, or public repository.

8. Troubleshooting Settings Problems

Incorrect settings can sometimes cause unexpected behavior. Use a systematic troubleshooting process rather than changing random options.

Problem Possible Check Recommended Action
Dates display incorrectly Source format and regional interpretation Verify the column type and locale in Power Query.
Data source asks for credentials Authentication and stored permissions Confirm the correct account and data-source access.
A preview feature is unavailable Power BI version and feature availability Review current product documentation and update status.
Data loading becomes slower Data volume, transformations, and model design Review queries and test performance changes individually.
A setting change has an unexpected effect Whether it is global or file-specific Review the changed option and restore the prior value if needed.

A Safe Troubleshooting Sequence

  1. Record the original behavior.
  2. Identify the setting that may be responsible.
  3. Read the option description.
  4. Change one setting at a time.
  5. Restart Power BI Desktop if required.
  6. Test the report and compare the result.
  7. Keep a backup before making major changes.

9. Hands-On Practice Exercise

Complete the following activity in Power BI Desktop to become familiar with the settings interface.

Exercise: Review Your Power BI Preferences

  1. Open Power BI Desktop.
  2. Locate the File menu.
  3. Open Options and settings, then select Options.
  4. Review the categories available in your version.
  5. Identify which options are global and which are file-specific.
  6. Review data-loading and regional preferences.
  7. Check whether preview features are listed.
  8. Review the available security and privacy-related options.
  9. Do not change any unfamiliar setting without understanding it.
  10. Close the dialog after completing your review.

Practice Checklist

  • ☐ I can locate the Options dialog.
  • ☐ I understand the difference between global and current-file settings.
  • ☐ I know why regional settings matter for dates and numbers.
  • ☐ I understand that preview features may change.
  • ☐ I know how to review data-source permissions safely.

10. Knowledge Check

Q1. Where can you generally find the Options dialog in Power BI Desktop?

Answer: In the File menu, under Options and settings.

Q2. What is the difference between global settings and current-file settings?

Answer: Global settings apply to the wider application environment, while current-file settings apply to the report being edited.

Q3. Why should you verify regional settings when importing dates?

Answer: Regional conventions can affect how date values are interpreted.

Q4. Why should preview features be tested carefully?

Answer: They may change between releases and may have limitations.

Q5. What should you do before changing an unfamiliar setting?

Answer: Read its description, understand its scope, and make a backup when the change could affect important work.

Q6. Why are data-source permissions important?

Answer: They help ensure that users access data only with appropriate authorization.

Summary

In this lesson, you learned how to locate Power BI Desktop options, distinguish between global and current-file settings, review data-loading preferences, understand regional settings, and recognize preview-feature limitations.

You also learned why security, privacy, credentials, and data-source permissions matter when working with business data.

Always review settings carefully, change one option at a time, test the result, and maintain backups of important reports.