To get the most out of this book

• Some prior knowledge of Power BI is recommended.
• A Power BI Desktop and Power BI service account (both free) is required.
• SQL Server (any edition, including Express and Developer, which are free) is required, with the AdventureWorksDW2022 database installed. This database is a free download and instructions for installation are covered in the first chapter of this book.
• Some recipes require additional Microsoft licenses such as Excel, Teams, PowerPoint, OneDrive, Power Automate, Power Apps, and Dynamics 365.
• Recipes for Microsoft Fabric require a Fabric capacity (trial or production).

Download the example code files

The code bundle for the book is hosted on GitHub at https://github.com/PacktPublishing/Power-BI-Cookbook-Third-Edition. We also have other code bundles from our rich catalog of books and videos available at https://github.com/PacktPublishing/. Check them out!

Download the color images

We also provide a PDF file that has color images of the screenshots/diagrams used in this book. You can download it here: https://packt.link/gbp/9781835464274.

Conventions used

There are a number of text conventions used throughout this book.

CodeInText: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. For example: “After completing these steps, the reports all have a live connection back to the dataset, CH5_R1_SalesAndFinanceDataset.”

A block of code is set as follows:

let
    Source = AdWorksDW,
    Data = Source{[Schema="dbo",Item="vCH3R2_Products"]}[Data]
in
    Data

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

Products Rows (Sales) = CALCULATE(COUNTROWS('Products'),'Internet Sales') 

Bold: Indicates a new term, an important word, or words that you see on the screen, for example, in menus or dialog boxes, also appear in the text like this. For example: “The Manage roles dialog box includes the ability to set Precedence.”

Warnings or important notes appear like this.

Tips and tricks appear like this.