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 File Management

Learn how to create, save, open, organize, and manage Power BI project files. Understand the PBIX format, file naming, backup practices, and the steps required to protect your work.

1. Introduction to Power BI File Management

File management is an important part of working with Power BI. A well-organized project makes it easier to locate reports, maintain previous versions, share work with colleagues, and continue a project later.

Power BI Desktop commonly uses the PBIX file format to store report content and its associated model information. Depending on the project, a report may also depend on external data sources, credentials, or refresh configuration.

Beginner Example

Samadhan creates a monthly sales report for his training project. He saves the file as MonthlySalesReport.pbix inside a dedicated project folder.

He keeps a backup copy before making major changes and uses clear file names to distinguish the original report from revised versions.

Remember: Save your work regularly and keep important project files in an organized location. A clear file structure helps prevent confusion and accidental loss of work.

2. Understanding Power BI File Types

Different file types serve different purposes in a Power BI workflow. Understanding these formats helps you identify which file to open, share, or use for data preparation.

PBIX .pbix Power BI report file Report and model content Can contain imported data PBIT .pbit Power BI template Reusable report structure Typically excludes imported data .csv Text data file Stores tabular data Can be imported into Power BI

Visual 1: Common file formats used in a Power BI workflow.

File Type Purpose Typical Use
.pbix Power BI Desktop report file. Save and continue editing a report and its model.
.pbit Power BI template file. Reuse report structure and model design for another project.
.csv Comma-separated text data file. Import tabular data into Power BI.
.xlsx Excel workbook. Import worksheets or supported Excel tables.
Important: A PBIX file may contain imported data, but a report using DirectQuery or other external connections can depend on its data source being available. Saving the report does not guarantee that every external dependency is included.

3. Creating and Saving a PBIX File

Saving a report creates a file that you can reopen and continue editing in Power BI Desktop. Choose a meaningful file name and store the report in the correct project folder.

Steps to Save a Report

  1. Open Power BI Desktop.
  2. Create a report or open an existing project.
  3. Select File from the application menu.
  4. Choose Save or Save As.
  5. Select the folder where you want to store the report.
  6. Enter a descriptive file name.
  7. Save the report as a PBIX file.

Example File Names

  • MonthlySalesReport.pbix
  • StudentPerformance.pbix
  • ProductAnalysis.pbix
  • RegionalSalesDashboard.pbix
Tip: Use names that describe the report's purpose. Avoid confusing names such as file1.pbix, newfile.pbix, or finalfinal.pbix.

4. Organizing Power BI Project Files

A clear folder structure makes it easier to find source files, report files, exported results, and backups. Keep related project files together and use consistent names.

PowerBI_Sales_Project Data SalesData.xlsx Reports MonthlySales.pbix Backups Previous versions Source Files Original input data Working Reports Current project files Backup Copies Recoverable versions Keep folders organized and use consistent file names Avoid overwriting important versions without a backup

Visual 2: Example folder structure for a Power BI project.

Recommended Folder Structure

  • Data: Source files used by the project.
  • Reports: Current PBIX report files.
  • Backups: Important previous versions.
  • Exports: Approved exported files, where needed.
  • Documentation: Notes about the report and data sources.

5. Opening and Reopening a Report

You can reopen a saved PBIX file to continue editing its pages, visuals, model, and supported settings. Before opening a report, make sure you know where the file is stored.

Steps to Open a PBIX File

  1. Launch Power BI Desktop.
  2. Select File and choose Open, or use the available open option.
  3. Browse to the folder containing the PBIX file.
  4. Select the report file.
  5. Wait for the report to load.
  6. Review the report and confirm that the expected content appears.

Example Scenario

Pradnya saved a report as StudentPerformance.pbix yesterday. Today, she opens the same file in Power BI Desktop to update the chart titles and add a new visual.

After completing the changes, she saves the file again so that her latest work is preserved.

Tip: If Power BI asks for data source credentials or cannot reach a connected source, check the connection and permissions. Opening a report file does not guarantee that every external source is available.

6. Save, Save As, and Version Management

Save and Save As help you preserve your work. Save updates the current file, while Save As lets you save a copy under another name or location.

Option Purpose Example
Save Save changes to the current file. Update the current MonthlySalesReport.pbix.
Save As Save a separate copy with a different name or location. Create MonthlySalesReport_Revision.pbix.
Backup copy Preserve an earlier version for recovery. Keep a dated copy before a major redesign.
Important: A filename containing "final" does not automatically create a backup. Keep a separate copy in a suitable location when you need to preserve an earlier version.

7. A Simple Version Management Workflow

Before making significant changes, create a backup copy. Use consistent naming conventions so you can distinguish the current working report from earlier versions.

1. Current Report MonthlySales.pbix 2. Create Backup Preserve old version 3. Make Changes Edit and validate 4. Save Updated Report Use a clear file name Verify the report and keep the backup safe Restore the earlier copy if needed

Visual 3: A practical workflow for managing report versions.

8. Exporting and Sharing Report Files

Power BI reports can be shared in different ways depending on the purpose, audience, permissions, and available features. Sharing a PBIX file is different from publishing a report to Power BI Service.

Method Purpose Important Consideration
Share a PBIX file Provide the editable report project. The recipient may need Power BI Desktop and access to required data sources.
Publish to Power BI Service Make a report available in an online workspace. Access depends on permissions, licensing, and organizational settings.
Export to PDF Provide a static version for review or printing. Interactive report features are not preserved as interactive elements.
Export data Provide data from a supported visual. Available export options depend on the visual, settings, and permissions.
Security reminder: Before sending a PBIX file, check whether it contains sensitive data or information that should not be shared. Follow your organization's data protection and access policies.

9. File Management Best Practices

Good file management practices reduce the risk of losing work, improve collaboration, and make report maintenance easier.

Use Clear Names Identify the report purpose and project version. Organize Folders Keep reports, source files, and backups organized. Keep Backups Preserve a copy before making major changes. Check Before Sharing Review sensitive data and access permissions.

Visual 4: Four essential Power BI file management practices.

  • Use descriptive file names and consistent naming conventions.
  • Save project files in a dedicated folder.
  • Keep a backup before major changes.
  • Check that source files remain accessible when required.
  • Remove unnecessary copies only after verifying that they are no longer needed.
  • Review sensitive information before sharing a report file.

10. Common Beginner Mistakes

Mistake 1: Using Unclear File Names

Solution: Use names such as MonthlySalesReport.pbix that clearly identify the report.

Mistake 2: Saving Only One Copy

Solution: Keep a suitable backup before major redesigns or structural changes.

Mistake 3: Moving Source Files Without Checking Connections

Solution: Confirm that the report can still access its required data sources after files are moved.

Mistake 4: Confusing PBIX and PBIT Files

Solution: Remember that PBIX is commonly used for an editable report project, while PBIT is used as a reusable template.

Mistake 5: Sharing Files Without Reviewing Their Contents

Solution: Check sensitive data, sharing permissions, and source dependencies before distribution.

11. Beginner Practice Questions

Q1. What is the common Power BI Desktop report file extension?

Answer: .pbix

Q2. What is a PBIT file commonly used for?

Answer: Reusing a Power BI report template.

Q3. What is the purpose of Save As?

Answer: Saving a separate copy under another name or location.

Q4. Why should you maintain backup copies?

Answer: To preserve earlier work and provide a recovery option if later changes cause problems.

Q5. Does sharing a PBIX file guarantee that its data sources will work for the recipient?

Answer: No. The recipient may need access, credentials, compatible software, and a working connection to external data sources.

Summary

In this lesson, you learned how to manage Power BI project files, save and reopen PBIX reports, understand common file formats, organize project folders, and maintain backup versions.

Good file management includes clear naming, organized storage, regular saving, careful version management, and checking source dependencies before sharing reports.