Addressing additional connectors

Thus far we have covered most, but not all, of the data-accessing functions available within the standard M library. Note that many more data-accessing functions are available within the global M environment in products such as Power BI Desktop. These additional data-accessing functions provide the ability to connect to a wide variety of specialized business systems such as customer relationship management (CRM) systems, enterprise resource management (ERP) systems, and others. These additional data-accessing functions come from external connectors included with Power BI Desktop.

External connectors are covered in Chapter 16, Enabling Extensions. A full list of data-accessing functions available in the global environment for Power BI Desktop can be found here: https://powerquery.how/accessing-data-functions/

Let’s briefly address the remaining data access functions available in the standard M library. These generally fall into two categories...