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).
• Tabular Editor 2.x (free).
• DAX Studio (free).
• SQL Server (any edition, including Express and Developer, which are free) with the AdventureWorksDW2019 database installed. This database is a free download and instructions for installing are available here: http://bit.ly/2OVQfG7.

Download the example code files

The code bundle for the book is hosted on GitHub at https://github.com/PacktPublishing/Microsoft-Power-BI-Cookbook-Second-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://static.packt-cdn.com/downloads/9781801813044_ColorImages.pdf.

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.