Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Power Query Cookbook
Power Query Cookbook

Power Query Cookbook: Use effective and powerful queries in Power BI Desktop and Dataflows to prepare and transform your data

eBook
$27.98 $39.99
Paperback
$48.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Power Query Cookbook

Chapter 2: Connecting to Fetch Data

One of the main aspects of Power Query is the wide range of data connectors. It offers a varied range of connection options and users can connect to data sources that reside on the cloud, on premises, and in local directories intuitively.

The idea is to treat all data sources at the same level and users (once they select the data they want to transform coming from different sources) can operate and combine them without caring about the data sources' original structure.

In this chapter, there will be an overview of connectors, and we will cover some of the best practices for how to connect to some of the most common connector types.

The recipes that will be covered in this chapter are the following:

  • Getting data and connector navigation
  • Creating a query from files
  • Creating a query from a folder
  • Creating a query from a database
  • Creating a query from a website

Technical requirements

For this chapter, you will be using the following:

You can find the data resources referred to in this chapter at https://github.com/PacktPublishing/Power-Query-Cookbook/tree/main/Chapter02.

Getting data and connector navigation

Power Query, thanks to its interface, offers an easy way to connect to data sources. In the previous chapter, you saw different authentication types, but here you will get an overview of the connector types and learn which one fits best. You will also learn the difference between preview (or beta) and general availability connectors.

Getting ready

For this recipe, you need to have Power BI Desktop running on your machine.

How to do it...

Open Power BI Desktop and you will be ready to perform the following steps:

  1. The first step in every version of the Power Query tool, whether it is the online or desktop version, is to click on Get data:
    Figure 2.1 – Get data in Power Query Desktop (left) and Get data in Power Query online (right)

    Figure 2.1 – Get data in Power Query Desktop (left) and Get data in Power Query online (right)

  2. Once you expand the Get data section, you will end up with the following view in the Power Query Desktop version:
Figure 2.2 – Get Data All connectors view in Power Query Desktop

Figure 2.2 – Get Data All connectors view in Power Query Desktop

And if you expand the same section in the Power Query online version, you will see the following:

Figure 2.3 – Get Data All categories view in Power Query online

Figure 2.3 – Get Data All categories view in Power Query online

Both versions have the following connectors divided into the same categories:

  • File: You can connect to different types of files, such as Excel, CSV/TXT, XML, JSON, Folder, PDF, and Parquet.
  • Database: You can connect to all mainstream databases such as Microsoft, Oracle, IBM, open source databases (MySQL, PostgreSQL, and MariaDB), Teradata, SAP, Amazon Redshift, Google BigQuery, Snowflake, and many others. This wide variety allows the user able to connect to the different sources and not have concerns about having the required data in only one standard data source.
  • Power Platform: You can connect live to Power BI datasets already published in the Power BI service. You will have the ability to connect to already prepared and transformed queries with the Power BI dataflow connectors and perform additional steps without doing everything from scratch.
  • Azure: You can connect to all Azure Data Services sources, such as Azure SQL Database, Azure Synapse, Azure Data Lake Storage, and to Azure open source services such as Azure Databricks and Azure HDInsight.
  • Online Services: You can connect to a wide range of third-party services and use native connectors to the Dynamics platform, Salesforce, Google Analytics, and other services that are continuously updated and released.
  • Other: This category collects more generic connectors, such as web connectors (used for getting data from websites, to make API calls, or to import files from the web), OData feeds, ODBC, and R and Python scripts. This set of connectors allows users to leverage some common connection logic that is used in other tools that can also be replicated with Power Query.

Users have to check what connectors are available in each version of Power Query – either the desktop or online version – and they have to research new connectors' availability. There are new ones both in beta (as shown in the following figure) and a general availability version with every release of Power Query. This list is constantly updated in the Microsoft documentation:

Figure 2.4 – Connector in the preview example

Creating a query from files

Power Query users (when they start to use and explore the tool) usually start by connecting to a local file. They can see from the start that the main file types are supported and each of these will display data in a readable format.

In this recipe, we will connect to an Excel file and see how to navigate and expand the different sheets and how to connect to cut-off text/CSV files.

Figure 2.5 – Get Data File section

Getting ready

In this recipe, in order to test different types of file connectors, you need to download the following files in a local folder:

  • The AdventureWorksSales Excel file
  • The FactResellerSales CSV file

In this example, we will refer to the C:\Data folder.

How to do it...

Once you have opened your Power BI Desktop application, perform the following steps:

  1. Go to Get data and click on Excel workbook:

    Figure 2.6 – Get data Excel connector

  2. Navigate to your local folder where you saved the Excel file, select it, and open it:
    Figure 2.7 – Local folder view

    Figure 2.7 – Local folder view

  3. Once you open it, the following window will pop up:
    Figure 2.8 – Excel data preview

    Figure 2.8 – Excel data preview

    Each item in the left pane matches an item in the Excel file. By only clicking on an item, you will see a preview of the data in the right pane and if you check it, you will include the item in the Power Query view. Therefore, flag the following queries: Customer, Date, and Product. Click on Transform Data.

  4. Each sheet will correspond to a query. From now on, you can perform all transformations as you would with any other data source type:
Figure 2.9 – Power Query interface

Figure 2.9 – Power Query interface

Let's add a connection to a CSV file:

  1. Click on Get data and select the Text/CSV connector:
    Figure 2.10 – Get data Text/CSV connector

    Figure 2.10 – Get data Text/CSV connector

  2. Navigate to the local folder where you saved the FactResellerSales CSV file. Select it and open it as in the previous section with the Excel file. The following window will pop up:
    Figure 2.11 – CSV data preview

    Figure 2.11 – CSV data preview

    For each file, you can define the following:

    a) File Origin: Define the file encoding (in this case, we will keep the default Unicode UTF-8).

    Figure 2.12 – Define the file encoding

    b) Delimiter: Select the right delimiter (in this case, we will keep the default Comma):

    Figure 2.13 – Define the delimiter

    Figure 2.13 – Define the delimiter

    c.) Data Type Detection: This will refer to the first applied step in Power Query when it detects data types for each column (in this case, we will detect data types based on the first 200 rows):

    Figure 2.14 – Define Data Type Detection

    Figure 2.14 – Define Data Type Detection

  3. On the bottom left of this window, you can also extract information from the CSV file by clicking on Extract Table Using Examples:
    Figure 2.15 – Extract Table Using Examples button

    Figure 2.15 – Extract Table Using Examples button

    The following section will appear:

    Figure 2.16 – Extract Table Using Examples interface

    Figure 2.16 – Extract Table Using Examples interface

  4. You can define your columns and which data to extract by filling in the table at the bottom. Have a look at the following example: name the first column ResellerKey and write in the first row the value 676, which is the first ResellerKey value you see in the example, and click on Enter:
    Figure 2.17 – Insert values example

    Figure 2.17 – Insert values example

  5. If you look at row 5 in Figure 2.18 (the left image), you can see that a wrong value has been detected. In this case, you can click on it and insert the right one and you will observe how all values in the column will be corrected:
    Figure 2.18 – Insert value detail example (left) and fill in missing or wrong values (right)

    Figure 2.18 – Insert value detail example (left) and fill in missing or wrong values (right)

  6. You can add a second column and repeat the steps done with the first. Name the second column EmployeeKey and insert the first value. Click Enter and you will see the corresponding rows filled:
    Figure 2.19 – Create a second column example

    Figure 2.19 – Create a second column example

  7. At the end, click on OK and you will see the CSV in the Power Query interface as shown in the following screenshot:
Figure 2.20 – Power Query interface

Figure 2.20 – Power Query interface

In the APPLIED STEPS section, you will see some activities mapped as a result of Extract Table Using Examples performed previously.

How it works...

Power Query, thanks to these file connectors, allows users to connect to single files and perform some pre-transformation tasks allowing them to load just relevant data in the usual interface. However, these connectors – Excel, TXT/CSV, and also Parquet file are related to single files. We will see in the following recipe how to connect to multiple files.

Creating a query from a folder

After playing with single files as the previous recipe showed, you need to load more files as their analytical workloads grow. If files are organized in folders, users can leverage a folder connector to load multiple files. Imagine having a collection of CSV files where each contains sales data for a specific day. What if we want to connect to a folder that contains these files, and we want to load them in Power Query as a single table? The way to go is to leverage the folder connector.

In this recipe, we will see how to connect to a folder with sales data in CSV format and a folder with finance data in Excel format (each file contains multiple sheets).

Getting ready

In this recipe, in order to test different types of file connectors, you need to download the following folders, each containing a set of files:

  • The CSVFiles folder containing the following CSV files:
Figure 2.21 – Local folder with CSV files

Figure 2.21 – Local folder with CSV files

  • The ExcelFiles folder containing the following Excel files:
Figure 2.22 – Local folder with Excel files

Figure 2.22 – Local folder with Excel files

In this example, I will refer to the following paths:

a) C:\Data\ExcelFiles

b) C:\Data\CSVFiles

You can find the folders and the related files referred to in this chapter at https://github.com/PacktPublishing/Power-Query-Cookbook/tree/main/Chapter02/ExcelFiles and https://github.com/PacktPublishing/Power-Query-Cookbook/tree/main/Chapter02/CSVFiles.

How to do it...

Open the Power BI Desktop application and perform the following steps:

  1. Go to Get data, click on Folder, and the following window will pop up. You can directly enter your folder path or click on Browse… and select it from the usual browsing section of your machine:
    Figure 2.23 – Folder connector

    Figure 2.23 – Folder connector

  2. Once you click on OK, you will see the following section with a list of files contained in the folder:
    Figure 2.24 – How files from the folder are displayed

    Figure 2.24 – How files from the folder are displayed

    At the bottom right, you can see some actions to perform:

    a) Combine & Transform Data: You can combine data by appending existing data at this phase and open Power Query.

    b) Combine & Load: You can append tables, load them, and start creating reports or analyzing data with Excel.

    c) Load: Load this list into the Power BI dataset as it is.

    d) Transform Data: This opens the Power Query interface and allows you to do custom transformations.

  3. Click on Transform Data and you will see the following columns:
Figure 2.25 – List of files in the Power Query view

Figure 2.25 – List of files in the Power Query view

From here, you can do one of these actions:

a) Expand a single CSV by clicking on Binary in the Content column:

Figure 2.26 – Expanded table

Figure 2.26 – Expanded table

b) Expand the Attributes column with some relevant information:

Figure 2.27 – Expand the Attributes column

Figure 2.27 – Expand the Attributes column

c) Combine files by clicking on the icon on the right, which means Combine:

Figure 2.28 – The Combine icon on the Content column

Figure 2.28 – The Combine icon on the Content column

Data combination is a concept that will be widely explored in Chapter 5, Combining Queries for Efficiency.

Now we will repeat the same steps but with the other folder containing Excel files:

  1. The view that opens is the following:
Figure 2.29 – List of Excel files in the Power Query interface

Figure 2.29 – List of Excel files in the Power Query interface

It is very similar to the one we saw previously because you can perform the following actions:

a) If you click on Binary in row 1, you will end up with a table with a list of the sheets contained in the Excel file FinanceData-OnlineChannel. If you click on Table in row 1, you will expand the sheet Sales:

Figure 2.30 – First level of the expanded table

Figure 2.30 – First level of the expanded table

b) If you click on Combine, the following window will pop up:

Figure 2.31 – Table preview during the Combine step

Figure 2.31 – Table preview during the Combine step

This built-in combine function will allow you to append the Sales sheets from three different Excel files. This topic will be widely explored in Chapter 5, Combining Queries for Efficiency.

How it works...

The idea of this recipe was to show you the potential of the folder connector because often users end up connecting multiple times to single files and then perform an append step. This takes time, and it is difficult to maintain when the number of files becomes bigger.

The folder connector allows you to refresh your data and perform all Power Query operations automatically. If you add a file in your folder and click on refresh, you will end up with a final table enriched with data coming from this last file.

Creating a query from a database

This recipe shows how to connect to a database and how tables and views are displayed while selecting which tables to display and work with in Power Query.

You have two generic options:

  • Select tables or views as you would see them with a database viewer such as SQL Server Management Studio.
  • Retrieve tables by writing SQL statements in a specific section that will pop up.

Getting ready

In this recipe, in order to connect to a SQL database, you need to have an Azure SQL Database instance with AdventureWorks data, database credentials, or access through Azure Active Directory authentication (log in with your Microsoft account).

How to do it...

Once you open the Power BI Desktop application, you are ready to perform the following steps:

  1. Go to Get data, click on More, and browse for Azure SQL database:
    Figure 2.32 - Azure Connectors section

    Figure 2.32 - Azure Connectors section

  2. Enter the following information (expanding Advanced options):

    a) Server: Server name

    b) Database: Adventureworks

    c) Data Connectivity mode: Import

    d) SQL statement: This is a SQL view executed using the data source based on two tables in the database. The view is built as a SQL join between FactResellerSales and DimSalesTerritory:

    SELECT s.[ProductKey]
          ,s.[SalesTerritoryKey]
          ,s.[SalesOrderNumber]
          ,s.[SalesOrderLineNumber]
          ,s.[RevisionNumber]
          ,s.[OrderQuantity]
          ,s.[UnitPrice]
          ,s.[ExtendedAmount]
          ,s.[UnitPriceDiscountPct]
          ,s.[DiscountAmount]
          ,s.[ProductStandardCost]
          ,s.[TotalProductCost]
          ,s.[SalesAmount]
          ,s.[OrderDate]
          ,p.[SalesTerritoryRegion]
          ,p.[SalesTerritoryCountry]
          ,p.[SalesTerritoryGroup]
      FROM [dbo].[FactResellerSalesXL_CCI] s
    LEFT OUTER JOIN [dbo].[DimSalesTerritory] p ON s.[SalesTerritoryKey] = [p.SalesTerritoryKey]
  3. Copy and paste the code in the SQL statement section in order to get this view as the output table you will work on in Power Query:
    Figure 2.33 – SQL Server database

    Figure 2.33 – SQL Server database

  4. Enter authentication details:
    Figure 2.34 – SQL Server database authentication

    Figure 2.34 – SQL Server database authentication

  5. After signing in, the output of the SQL statement will pop up as follows:
    Figure 2.35 – Table preview

    Figure 2.35 – Table preview

  6. Click on Transform Data in order to open the Power Query interface:
    Figure 2.36 – Data preview in Power Query

    Figure 2.36 – Data preview in Power Query

  7. Click on Get data and select the connector Azure SQL Database. In this case, we won't enter a SQL statement, but we will select an existing table in the database:
    Figure 2.37 – SQL Server database connector

    Figure 2.37 – SQL Server database connector

  8. After signing in, a preview interface will appear, and you will be able to select the tables that you want to open in Power Query after clicking on OK:
    Figure 2.38 – SQL Database Navigator

    Figure 2.38 – SQL Database Navigator

  9. You will see on the left a set of queries as an output of connecting directly to the database tables and writing a SQL statement querying the database as you would do with any other database viewing tool:
Figure 2.39 – Data preview in Power Query

Figure 2.39 – Data preview in Power Query

If you open Advanced Editor for both types, you will notice that if you need to change the SQL code or you have to change the table name, you can do that directly from the Advanced Editor window:

a) The SalesData table's Advanced Editor code where you can see the details of the query run against the data source:

Figure 2.40 – Advanced Editor code for a SalesData query

Figure 2.40 – Advanced Editor code for a SalesData query

b) The DimDate table's Advanced Editor code where you can see the details of the connection Source, the database retrieved from the server, Adventureworks, and the table selected from the data source DimDate:

Figure 2.41 – Advanced Editor code for the DimDate Query

Figure 2.41 – Advanced Editor code for the DimDate Query

How it works...

The Azure SQL Database connector also reflects how other database connectors work. If you connect to Amazon Redshift or an Oracle database, the experience will be very similar. Power Query provides a wide range of options for relational data sources and some of them may need the installation of specific drivers. For example, if you connect to SAP or Oracle, you have to install additional components (for example, in Oracle, the additional components will be the Oracle Data Access Components (ODAC)).

Creating a query from a website

Data is not only located in databases, but also in files, online services, and third-party applications as a growing number of users require the ability to connect to information available on the web. The idea behind the web connector is to allow easy and intuitive information extraction from websites. In this section, we will explore the possibilities of this connector and we will connect to a web page to extract data in an easily readable format.

Getting ready

For this recipe, you need Power BI Desktop and access to the following website: https://www.packtpub.com/eu/all-products.

How to do it...

In this recipe, the idea is to retrieve data from the Packt online catalog. By clicking on the preceding link, you will see the following site:

Figure 2.42 – Packt online book catalog

Figure 2.42 – Packt online book catalog

Imagine you want to extract data regarding the books available on this site.

Open Power BI Desktop and follow these steps:

  1. Go to Get data and click on Web. Insert the link in the URL field:
    Figure 2.43 – Web connector

    Figure 2.43 – Web connector

  2. Authenticate as Anonymous (since it is a public website) and click on Connect:
    Figure 2.44 – Web connector authentication

    Figure 2.44 – Web connector authentication

  3. After authenticating, the following preview window will pop up where, on the left, you can find a list of suggested tables and, on the right, you can see a data preview:
    Figure 2.45 – Web tables preview

    Figure 2.45 – Web tables preview

  4. If you click on Transform Data, you will open the Power Query interface and then you can rename and clean up your data:
Figure 2.46 – Web data preview in Power Query

Figure 2.46 – Web data preview in Power Query

We will try another feature to extract data from the website and test an advanced link by inserting filters at the URL level:

  1. Go to Get data and select the Web connector. Click on Advanced and split the URL https://www.packtpub.com/eu/all-products?released=Available&tool=Azure&vendor=Microsoft into three parts as in the next screenshot and click on OK:
    Figure 2.47 – Web connector advanced

    Figure 2.47 – Web connector advanced

  2. The preview window will pop up. Click on Add Table Using Examples:
    Figure 2.48 – Add Table Using Examples button

    Figure 2.48 – Add Table Using Examples button

  3. Start naming the columns as follows:

    a) Title

    b) Author

    c) Nr. Pages

    d) Publication Date

    The columns should look like the ones in the following screenshot:

    Figure 2.49 – Add Table Using Examples

    Figure 2.49 – Add Table Using Examples

  4. Start filling in the first rows of each column and you'll see the other rows populate automatically:
    Figure 2.50 – Add Table Using Examples details

    Figure 2.50 – Add Table Using Examples details

  5. Click on OK and you will generate a table within the Custom Tables section that you can select and load into Power Query:
Figure 2.51 – Insert custom table from examples

Figure 2.51 – Insert custom table from examples

With these simple steps, it is possible to connect and extract information from a website with a no-code approach. Users can focus on the content of data and not on the process of how to connect since Power Query allows them to do it in a few steps.

How it works...

This web connector not only allows users to connect to data from web pages by leveraging pre-defined tables identified by Power Query, but it also gives the ability to provide data examples from a web page and generate a custom table with relevant information for the user.

Left arrow icon Right arrow icon
Download code icon Download Code

Key benefits

  • Collect, combine, and transform data using Power Query's data connectivity and data preparation features
  • Overcome the problems faced while accessing data from multiple sources and reshape it to meet your business requirements
  • Explore how the M language can be used to write your own customized solutions

Description

Power Query is a data preparation tool that enables data engineers and business users to connect, reshape, enrich, and transform their data to facilitate relevant business insights and analysis. With Power Query's wide range of features, you can perform no-code transformations and complex M code functions at the same time to get the most out of your data. This Power Query book will help you to connect to data sources, achieve intuitive transformations, and get to grips with preparation practices. Starting with a general overview of Power Query and what it can do, the book advances to cover more complex topics such as M code and performance optimization. You'll learn how to extend these capabilities by gradually stepping away from the Power Query GUI and into the M programming language. Additionally, the book also shows you how to use Power Query Online within Power BI Dataflows. By the end of the book, you'll be able to leverage your source data, understand your data better, and enrich it with a full stack of no-code and custom features that you'll learn to design by yourself for your business requirements.

Who is this book for?

This book is for data analysts, BI developers, data engineers, and anyone looking for a desk reference guide to learn how Power Query can be used with different Microsoft products to handle data of varying complexity. Beginner-level knowledge of Power BI and the M Language will help you to get the best out of this book.

What you will learn

  • Understand how to use Power Query to connect and explore data
  • Explore ways to reshape and enrich data
  • Discover the potential of Power Query across the Microsoft platform
  • Build complex and custom transformations
  • Use M code to write new queries against data sources
  • Use the Power Query Online tool within Power BI Dataflows
  • Implement best practices such as reusing dataflows, optimizing expanding table operations, and field mapping

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Oct 15, 2021
Length: 412 pages
Edition : 1st
Language : English
ISBN-13 : 9781800569485
Vendor :
Microsoft
Category :
Languages :
Concepts :
Tools :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Oct 15, 2021
Length: 412 pages
Edition : 1st
Language : English
ISBN-13 : 9781800569485
Vendor :
Microsoft
Category :
Languages :
Concepts :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just $5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total $ 188.97
Microsoft Power BI Cookbook
$69.99
Power Query Cookbook
$48.99
Expert Data Modeling with Power BI
$69.99
Total $ 188.97 Stars icon

Table of Contents

11 Chapters
Chapter 1: Getting Started with Power Query Chevron down icon Chevron up icon
Chapter 2: Connecting to Fetch Data Chevron down icon Chevron up icon
Chapter 3: Data Exploration in Power Query Chevron down icon Chevron up icon
Chapter 4: Reshaping Your Data Chevron down icon Chevron up icon
Chapter 5: Combining Queries for Efficiency Chevron down icon Chevron up icon
Chapter 6: Optimizing Power Query Performance Chevron down icon Chevron up icon
Chapter 7: Leveraging the M Language Chevron down icon Chevron up icon
Chapter 8: Adding Value to Your Data Chevron down icon Chevron up icon
Chapter 9: Performance Tuning with Power BI Dataflows Chevron down icon Chevron up icon
Chapter 10: Implementing Query Diagnostics Chevron down icon Chevron up icon
Other Books You May Enjoy Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.5
(14 Ratings)
5 star 64.3%
4 star 28.6%
3 star 0%
2 star 7.1%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




Patrick Borosch Oct 16, 2021
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Gleich vorweg: ich kenne die Autorin und arbeite mit ihr zusammen.Das Buch enthält Mini-Projekte, sog. "Rezepte" für alle Bereiche, mit denen man als Power BI / Power Query-Entwickler*innen im täglichen Leben konfrontiert wird. Als Leser*in bekommt man im Rezept zunächst alle notwendigen "Zutaten" (technische Anforderungen/Voraussetzungen) präsentiert und kann dann direkt an die Umsetzung gehen. Diese Strukturierung erlaubt es auch erfahreneren Lesern*innen flexibel zu den fortgeschritteneren Themen zu springen, da die Kapitel voneinander unabhängig gestaltet sind.Auch Fortgeschrittene PowerBI / PowerQuery-Entwickler*innen werden von diesem Buch profitieren. Andrea konzentriert sich auf das Notwendige und lässt die Schnörkel aus. Damit kann man ein Thema schnell erfassen und umsetzen.Aus meiner Sicht ist das Buch definitiv eine Referenz für alle, die sich mit dem Thema Power Query beschäftigen. Es hilft Anfängern*innen und Fortgeschrittenen gleichermaßen und sollte in jedem Regal stehen, wo mit Power BI, Synapse Pipelines und Azure Data Factory gearbeitet wird.
Amazon Verified review Amazon
charitha Nov 22, 2021
Full star icon Full star icon Full star icon Full star icon Full star icon 5
Power Query Cookbook by Andrea Janicijevic is a comprehensive Support document for any PBI dataflows. It has a gradual progression from the basics through the expert deployment practices. The step-by-step details on each concept helps any novice BI analyst to be accomplish Data analytics in Power Query. The deep dive to M language and dataflows is explained elaborately. There are advanced concepts like Power Apps , Common Data Model and Diagnostics covered neatly.The book can be a used a reference material to someone with no coding experience and at the same time, it would help a seasoned PBI programmer.
Amazon Verified review Amazon
Amazon Customer Nov 20, 2021
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The book is a comprehensive Support document for any Power BI dataflows. It has a gradual progression from the basics through the expert deployment practices. The step-by-step details on each concept helps any novice BI analyst to be accomplish Data analytics in Power Query. The deep dive to M language and dataflows is explained elaborately. There are advanced concepts like Power Apps , Common Data Model and Diagnostics covered neatly.The book can be a used as a reference material to someone with no coding experience and at the same time, it would help a seasoned PBI programmer.
Amazon Verified review Amazon
Chris Wagner Oct 19, 2021
Full star icon Full star icon Full star icon Full star icon Full star icon 5
The Power Query Cookbook is FIRE for anyone looking to learn more about working with data and Power BI.This book starts you off with the basics of Power Query but then works your way into advanced topics. Anyone working with Power BI should have a copy of this book on their bookshelf.
Amazon Verified review Amazon
Kristian B. Oct 15, 2021
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I had the opportunity to sneak peek into Andrea Janicijevic's book "Power Query Cookbook" published by Packt and it's amazing! If you're wondering how #PowerQuery works, how to use it to transfer and modify your #Data, this is a must read! Starting with #PowerBI and #PowerQuery? Using #Excel and want to enhance your skills with #PowerQuery? Go and get this book!
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.