Skip to Main Content
Learn Power BI
book

Learn Power BI

by Greg Deckler
September 2019
Beginner to intermediate content levelBeginner to intermediate
362 pages
9h 22m
English
Packt Publishing
Content preview from Learn Power BI

Creating your first query

In order to determine whether or not PTO should be approved, it is important to understand where the company is with respect to budgets and forecasts. Whether or not the company, department, and/or location is on target in terms of its budget can be an important consideration when approving or denying time off.

Unlike the calendar table from Chapter 2Up and Running with Power BI Desktop, where we used DAX to create a calculated table, this time, we will import data into our data model using a query.

To create a query, we will implement the following steps:

  1. Choose Get Data from the Home tab of the ribbon. Note the default list of potential data sources and select More... at the bottom of the list:
Figure 1: The ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Learn Power BI - Second Edition

Learn Power BI - Second Edition

Greg Deckler

Publisher Resources

ISBN: 9781838644482Supplemental Content