Accessing and Retrieving Data

In this chapter, we will cover the following recipes:

• Viewing and analyzing M functions in the Query Editor
• Establishing and managing connections to data sources
• Building source queries for DirectQuery models
• Importing data to Power BI Desktop models
• Applying multiple filtering conditions
• Choosing columns and column names
• Transforming and cleansing source data
• Creating custom and conditional columns
• Integrating multiple queries
• Choosing column data types
• Visualizing the M library