-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Power Query Cookbook
By :

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.
For this recipe, you need to have Power BI Desktop running on your machine.
Open Power BI Desktop and you will be ready to perform the following steps:
Figure 2.1 – Get data in Power Query Desktop (left) and Get data in Power Query online (right)
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
Both versions have the following connectors divided into the same categories:
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