Discovering and Loading Data with Power Query
Before you can present any analysis or insight, you need source data. Your source data could be in many places and in many formats. Nonetheless, you need to access it, look at it, and quite possibly clean it up to some extent. You may also need to join separate data sources before you can shape the data into a coherent data set using PowerPivot, deliver the results using Power View or Power Map, and then share it using Power BI.
Discovering, loading, cleaning, and modifying source data is where Power Query comes in. Using this, the latest addition to the Microsoft self-service business ...