March 2024
Intermediate to advanced
814 pages
22h 10m
English
As you’ve learned in previous chapters, Power BI uses Power Query as a tool for extracting, transforming, and loading (ETL) operations. This tool is really very powerful – it allows you to extract data from a wide variety of data sources and then easily transform it with very user-friendly options. This includes a graphical query editor for point-and-click transformations, the ability to extract data from multiple sources, comprehensive column and row transformations, data cleaning functions, and the ability to perform simple calculations. The output of these transformations is persisted in the Power BI data model. Power Query is a read-only tool. In fact, its biggest limitation is its inability ...
Read now
Unlock full access